Contents
REVOKE
An SQL command for removing privileges from a user
REVOKE
is a utility command for remoiving privileges on database objects and databases from a user.
REVOKE
has always been present in PostgreSQL.
Change history
- PostgreSQL 15
REVOKE [ GRANT OPTION FOR ] { { SET | ALTER SYSTEM } [, ...] | ALL [ PRIVILEGES ] } ON PARAMETER ...
syntax added (commit a0ffa885)
- PostgreSQL 14
- PostgreSQL 8.2
REVOKE ... ON RULE
syntax deprecated (commit 7bae5a28)
Examples
Basic usage example for REVOKE
:
postgres=# REVOKE pg_read_all_stats FROM foo; REVOKE ROLE
References
- PostgreSQL documentation: REVOKE