Ability to create tables
От | Ron Johnson |
---|---|
Тема | Ability to create tables |
Дата | |
Msg-id | 2b6740bf-cab4-6ddf-2928-665d632efb41@cox.net обсуждение исходный текст |
Ответы |
Re: Ability to create tables
|
Список | pgsql-general |
Hi, Archaic v9.2.7 Even though I revoked the CREATE priv on role ABCREADONLY, it's still able to create tables. What can I do to prevent this? \c postgres CREATE ROLE "ABCREADONLY" LOGIN INHERIT PASSWORD 'Flying.Fox'; GRANT CONNECT ON DATABASE "ABC123" TO "ABCREADONLY"; \c ABC123 GRANT USAGE ON SCHEMA public, ABC, tms TO "ABCREADONLY"; GRANT SELECT ON ALL TABLES IN SCHEMA public, ABC, tms TO "ABCREADONLY"; ALTER DEFAULT PRIVILEGES IN SCHEMA public, ABC, tms GRANT SELECT ON TABLES TO "ABCREADONLY"; $ psql -c 'revoke create on database "ABC123" from "ABCREADONLY";' REVOKE $ psql -d ABC123 -U ABCREADONLY -c "create table bar (f1 integer);" CREATE TABLE $ psql -d ABC123 -U ABCREADONLY -c "\d bar" Table "public.bar" Column | Type | Modifiers --------+---------+----------- f1 | integer | Thanks -- Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: