• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (beta3)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5 (EOL)

Version charts

Useful overviews

Useful links

ALTER DEFAULT PRIVILEGES

ALTER DEFAULT PRIVILEGES is a utility command for defining default object access privileges.

ALTER DEFAULT PRIVILEGES was introduced 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

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

Categories

See also