Contents
ALTER DEFAULT PRIVILEGES
An SQL command for defining default object access privileges
ALTER DEFAULT PRIVILEGES
is a utility command for defining default object access privileges.
ALTER DEFAULT PRIVILEGES
was added in PostgreSQL 9.0.
Change history
- PostgreSQL 10
- support for altering privileges on schemas added (commit ab89e465)
- PostgreSQL 9.2
- support for altering privileges on types added (commit 72920557)
- PostgreSQL 9.0
- added (commit 249724cb)
Examples
Usage example for ALTER DEFAULT PRIVILEGES
:
postgres=# CREATE SCHEMA someschema; CREATE SCHEMA
postgres=# ALTER DEFAULT PRIVILEGES IN SCHEMA someschema GRANT SELECT ON TABLES TO foo; ALTER DEFAULT PRIVILEGES
postgres=# \ddp Default access privileges Owner | Schema | Type | Access privileges ----------+------------+-------+------------------- postgres | someschema | table | foo=r/postgres (1 row)
References
- PostgreSQL documentation: ALTER DEFAULT PRIVILEGES