Ability to create tables
Ron Johnson <ron.l.johnson@cox.net>
From: Ron Johnson <ron.l.johnson@cox.net>
To: pgsql-general@lists.postgresql.org
Date: 2018-03-09T23:13:48Z
Lists: 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.