Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Alter default privileges

Set permissions that future objects should inherit.

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

Alter default privileges

sql
sql
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO appuser;
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
Revoke update privilege
Remove write capability from a role.
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