Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

REVOKE

REVOKE removes previously granted privileges or role-membership options. It can remove access, remove only the ability to grant access, or recursively remove dependent grants.

Last updated

Syntax

REVOKE [ GRANT OPTION FOR ] { privilege [, ...] | ALL [ PRIVILEGES ] } ON object FROM role_specification [, ...] [ GRANTED BY role_specification ] [ CASCADE | RESTRICT ]

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • GRANT
  • ALTER DEFAULT PRIVILEGES
  • SET ROLE

Source: PostgreSQL: Documentation: 18: REVOKE. Checked 2026-11-03.