列出表、视图和序列和它们相关的访问权限
最近更新时间: 2024-06-12 15:06:00
显示所有对象的访问权限。
postgres=# \dp Accessprivileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+--------------------+----------+-------------------+-------------------+---------- public | pg_stat_statements | view | tbase=arwdDxt/tbase+| | | | | =r/tbase | | public | tbase | table | tbase=arwdDxt/tbase+| | | | | pgxc=r/tbase | | public | tbase_seq | sequence | tbase=rwU/tbase +| | | | | pgxc=rwU/tbase | | (3 rows)
\dp+某个对象名,只显示匹配的对象。
postgres=# \dp tbase Accessprivileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+-------+-------+-------------------+-------------------+---------- public | tbase | table | tbase=arwdDxt/tbase+| | | | | pgxc=r/tbase | | (1 row) postgres=# \dp public.* Accessprivileges Schema | Name | Type | Access privileges | Column privileges | Policies --------+--------------------+----------+-------------------+-------------------+---------- public | pg_stat_statements | view | tbase=arwdDxt/tbase+| | | | | =r/tbase | | public | tbase | table | tbase=arwdDxt/tbase+| | | | | pgxc=r/tbase | | public | tbase_seq | sequence | tbase=rwU/tbase +| | | | | pgxc=rwU/tbase | | (3 rows)