Re: Ability to create tables

On 03/09/2018 05:46 PM, Tom Lane wrote: Ron Johnson writes: Even though I revoked the  CREATE priv on role ABCREADONLY, it's still able to create tables.  What can I do to prevent this? $ psql -c 'revoke create on database "ABC123" from "ABCREADONLY";' That revokes the

Re: Ability to create tables

Ron Johnson writes: > Even though I revoked the  CREATE priv on role ABCREADONLY, it's still able > to create tables.  What can I do to prevent this? > $ psql -c 'revoke create on database "ABC123" from "ABCREADONLY";' That revokes the ability to create new schemas

Ability to create tables

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