本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。
顯示使用者、角色或物件的授予。物件可以是資料庫、結構描述、資料表或函數。
語法
SHOW GRANTS ON {DATABASE database_name | FUNCTION function_name | SCHEMA schema_name | TABLE table_name} [FOR {username | ROLE role_name | PUBLIC}] [LIMIT row_limit]
參數
- database_name
-
要顯示授予的資料庫名稱。
- function_name
-
要顯示授予的函數名稱。
- schema_name
-
要顯示授予的結構描述名稱。
- table_name
-
要顯示授予的資料表名稱。
- FOR 使用者名稱
-
表示顯示使用者的授予。
- FOR ROLE role_name
-
表示顯示角色的授予。
- 適用於 PUBLIC
-
表示顯示 PUBLIC 的授予。
- row_limit
-
傳回的最大資料列數。row_limit 可以是 0 到 10,000。
範例
下列範例顯示名為 之資料庫上的所有授予dev。
SHOW GRANTS ON DATABASE dev;
database_name | privilege_type | identity_id | identity_name | identity_type | admin_option | privilege_scope
---------------+----------------+-------------+---------------+---------------+--------------+-----------------
dev | TRUNCATE | 101 | alice | user | f | TABLES
dev | DROP | 101 | alice | user | f | TABLES
dev | INSERT | 101 | alice | user | f | TABLES
dev | ALTER | 101 | alice | user | f | TABLES
dev | TEMP | 0 | public | public | f | DATABASE
dev | DELETE | 101 | alice | user | f | TABLES
dev | SELECT | 101 | alice | user | f | TABLES
dev | UPDATE | 101 | alice | user | f | TABLES
dev | REFERENCES | 101 | alice | user | f | TABLES
(9 rows)下列命令顯示名為 之結構描述的所有授予demo。
SHOW GRANTS ON SCHEMA demo;
schema_name | object_name | object_type | privilege_type | identity_id | identity_name | identity_type | admin_option | privilege_scope
-------------+-------------+-------------+----------------+-------------+---------------+---------------+--------------+-----------------
demo | demo | SCHEMA | ALTER | 101 | alice | user | f | SCHEMA
demo | demo | SCHEMA | DROP | 101 | alice | user | f | SCHEMA
demo | demo | SCHEMA | USAGE | 101 | alice | user | f | SCHEMA
demo | demo | SCHEMA | CREATE | 101 | alice | user | f | SCHEMA
(4 rows)下列命令顯示名為 之使用者的所有授予alice。
SHOW GRANTS FOR alice;
database_name | schema_name | object_name | object_type | privilege_type | identity_id | identity_name | identity_type | privilege_scope
---------------+-------------+-------------+-------------+----------------+-------------+---------------+---------------+-----------------
dev | | | DATABASE | INSERT | 101 | alice | user | TABLES
dev | | | DATABASE | SELECT | 101 | alice | user | TABLES
dev | | | DATABASE | UPDATE | 101 | alice | user | TABLES
dev | | | DATABASE | DELETE | 101 | alice | user | TABLES
dev | | | DATABASE | REFERENCES | 101 | alice | user | TABLES
dev | | | DATABASE | DROP | 101 | alice | user | TABLES
dev | | | DATABASE | TRUNCATE | 101 | alice | user | TABLES
dev | | | DATABASE | ALTER | 101 | alice | user | TABLES
dev | public | t1 | TABLE | INSERT | 101 | alice | user | TABLE
dev | public | t1 | TABLE | SELECT | 101 | alice | user | TABLE
dev | public | t1 | TABLE | UPDATE | 101 | alice | user | TABLE
dev | public | t1 | TABLE | DELETE | 101 | alice | user | TABLE
dev | public | t1 | TABLE | RULE | 101 | alice | user | TABLE
dev | public | t1 | TABLE | REFERENCES | 101 | alice | user | TABLE
dev | public | t1 | TABLE | TRIGGER | 101 | alice | user | TABLE
dev | public | t1 | TABLE | DROP | 101 | alice | user | TABLE
dev | public | t1 | TABLE | TRUNCATE | 101 | alice | user | TABLE
dev | public | t1 | TABLE | ALTER | 101 | alice | user | TABLE
dev | demo | | SCHEMA | USAGE | 101 | alice | user | SCHEMA
dev | demo | | SCHEMA | CREATE | 101 | alice | user | SCHEMA
dev | demo | | SCHEMA | DROP | 101 | alice | user | SCHEMA
dev | demo | | SCHEMA | ALTER | 101 | alice | user | SCHEMA
(22 rows)