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

Examples

Basic usage example for REVOKE:

postgres=# REVOKE pg_read_all_stats FROM foo;
REVOKE ROLE
  • PostgreSQL documentation: REVOKE

Categories

SQL command, Utility command

See also

GRANT, ALTER DEFAULT PRIVILEGES