Re: Ability to create tables

2018-03-09 Thread Ron Johnson
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 ability to create new sc

Re: Ability to create tables

2018-03-09 Thread Tom Lane
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 within that database (which I