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
