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
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
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 USA