From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Venkataramana Aitla <avr1984(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Issue with grant & revoke |
Date: | 2018-01-18 13:08:11 |
Message-ID: | 1516280891.924.45.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Davlet Panech | 2018-01-18 17:13:33 | Re: Abnormally high memory usage/OOM triggered |
Previous Message | Venkataramana Aitla | 2018-01-18 12:32:12 | Issue with grant & revoke |