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
GRANTED BYclause added (commit 6aaaa76b)
- PostgreSQL 8.2
REVOKE ... ON RULEsyntax deprecated (commit 7bae5a28)
Examples
Basic usage example for REVOKE:
postgres=# REVOKE pg_read_all_stats FROM foo; REVOKE ROLE
References
- PostgreSQL documentation: REVOKE