• Browse categories
• Random entry
• PostgreSQL releases
  • PostgreSQL 16 (dev)
  • PostgreSQL 15 (rc2)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

REVOKE

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 BY clause added (commit 6aaaa76b)
  • CURRENT_ROLE accepted as role specification (commit 45b98057)
• PostgreSQL 8.2
  • REVOKE ... ON RULE syntax deprecated (commit 7bae5a28)

Examples

postgres=# REVOKE pg_read_all_stats FROM foo;
REVOKE ROLE

References

Categories

See also