Re: Issue with grant & revoke - Mailing list pgsql-admin

Venkataramana Aitla wrote:
> How can we revoke alter and drop privileges from user/schema...??

Use the GRANT and REVOKE statements:

https://www.postgresql.org/docs/current/static/sql-grant.html
https://www.postgresql.org/docs/current/static/sql-revoke.html

Read the chapter on privileges:

https://www.postgresql.org/docs/current/static/ddl-priv.html

Privileges are additive, so if you try to revoke a privilege
that was not granted, it will do nothing.

In psql, use \z to list a table's privileges and \dn+
to list privileges on a schema.

Yours,
Laurenz Albe