pg_default_acl

存储将分配给新创建对象的初始权限的系统表

pg_default_acl 是一个系统目录表，用于存储由 ALTER DEFAULT PRIVILEGES 命令定义的、将分配给新创建对象的初始权限。

pg_default_acl 在 PostgreSQL 9.0 中添加。

psql

您可以在 psql 中使用斜杠命令 \ddp 来查询 pg_default_acl 的内容。

按 PostgreSQL 版本定义

pg_default_acl (PostgreSQL 19)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 18)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 17)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 16)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 15)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 14)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" PRIMARY KEY, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE CONSTRAINT, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 13)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 12)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 oid             | oid       |           | not null | 
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           | not null | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 11)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           |          | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 10)

              Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Collation | Nullable | Default 
-----------------+-----------+-----------+----------+---------
 defaclrole      | oid       |           | not null | 
 defaclnamespace | oid       |           | not null | 
 defaclobjtype   | "char"    |           | not null | 
 defaclacl       | aclitem[] |           |          | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.6)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.5)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.4)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.3)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.2)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.1)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

pg_default_acl (PostgreSQL 9.0)

    Table "pg_catalog.pg_default_acl"
     Column      |   Type    | Modifiers 
-----------------+-----------+-----------
 defaclrole      | oid       | not null
 defaclnamespace | oid       | not null
 defaclobjtype   | "char"    | not null
 defaclacl       | aclitem[] | 
Indexes:
    "pg_default_acl_oid_index" UNIQUE, btree (oid)
    "pg_default_acl_role_nsp_obj_index" UNIQUE, btree (defaclrole, defaclnamespace, defaclobjtype)

文档: pg_default_acl

变更历史

此表自首次添加以来未发生更改。

PostgreSQL 9.0
- 已添加 (commit 249724cb)

示例

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)

postgres=# SELECT * FROM pg_default_acl;
 defaclrole | defaclnamespace | defaclobjtype |    defaclacl
------------+-----------------+---------------+------------------
         10 |           16456 | r             | {foo=r/postgres}
(1 row)

参考资料

PostgreSQL 文档: pg_default_acl

有用链接

PostgreSQL Wiki: DefaultACL - 功能开发讨论

另请参阅

ALTER DEFAULT PRIVILEGES

反馈

提交有关 "pg_default_acl" 的任何评论、建议或更正请 在此处。

版本图表

实用概述

有用链接

咖啡

目录

pg_default_acl

psql

按 PostgreSQL 版本定义

pg_default_acl (PostgreSQL 19)

pg_default_acl (PostgreSQL 18)

pg_default_acl (PostgreSQL 17)

pg_default_acl (PostgreSQL 16)

pg_default_acl (PostgreSQL 15)

pg_default_acl (PostgreSQL 14)

pg_default_acl (PostgreSQL 13)

pg_default_acl (PostgreSQL 12)

pg_default_acl (PostgreSQL 11)

pg_default_acl (PostgreSQL 10)

pg_default_acl (PostgreSQL 9.6)

pg_default_acl (PostgreSQL 9.5)

pg_default_acl (PostgreSQL 9.4)

pg_default_acl (PostgreSQL 9.3)

pg_default_acl (PostgreSQL 9.2)

pg_default_acl (PostgreSQL 9.1)

pg_default_acl (PostgreSQL 9.0)

变更历史

示例

参考资料

有用链接

分类

另请参阅

反馈