Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
Examples
References
Categories
See also

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 BY clause added (commit 6aaaa76b)
- CURRENT_ROLE accepted as role specification (commit 45b98057)
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

Categories

See also

GRANT, ALTER DEFAULT PRIVILEGES