Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Revoke update privilege

Remove write capability from a role.

Back to sheetBrowse commands
Sign in to save
Section: Security, Grants, and Default Privileges

Revoke update privilege

sql
sql
REVOKE UPDATE ON TABLE public.users FROM readonly;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Security, Grants, and Default Privileges
Grant table select
Allow read access to a table.
OpenIn sheetsqlsame section
Grant schema usage
Allow object lookup inside a schema.
OpenIn sheetsqlsame section
Grant sequence usage
Allow use of sequences for inserts or reads.
OpenIn sheetsqlsame section
Alter default privileges
Set permissions that future objects should inherit.
OpenIn sheetsqlsame section
Change object owner
Transfer ownership of an object to another role.
OpenIn sheetsqlsame section
Set active role
Temporarily assume another role for the session.
OpenIn sheetsqlsame section