Issue with grant & revoke
Issue with grant & revoke
От:
Venkataramana Aitla <avr1984@gmail.com>
Дата:
Hi Team,
How can we revoke alter and drop privileges from user/schema...??
Re: Issue with grant & revoke
От:
Laurenz Albe <laurenz.albe@cybertec.at>
Дата:
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