SHOW PRIVILEGES
功能描述
SHOW PRIVILEGES用于查看当前数据库中的权限信息清单。
注意事项
该功能仅在数据库兼容模式为MySQL时支持（即数据库实例初始化时指定DBCOMPATIBILITY='B'）。
语法格式
SHOW PRIVILEGES;
参数说明
无。
示例
show privileges;
返回结果为：
Privilege | Context | Comment
----------------------+------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------
Alter | Large object,Sequence,Database,Foreign Server,Function,Node group,Schema,Tablespace,Type,Directory,Package | To alter the 'objects'
Alter any index | Index | To alter any index
Alter any sequence | Sequence | To alter any sequence
Alter any table | Table | To alter any table
Alter any trigger | Trigger | To alter any trigger
Alter any type | Type | To alter any type
Comment | Table | To comment on table
Compute | Node group | To compute on node group
Connect | Database | To connect database
Create | Database,Schema,Tablespace,Node group | To create database,schema,tablespace,node group
Create any function | Function | To create any function
Create any index | Index | To create any index
Create any package | Package | To create any package
Create any sequence | Sequence | To create any sequence
Create any synonym | Synonym | To create any synonym
Create any table | Table | To create any table
Create any trigger | Trigger | To create any trigger
Create any type | Type | To create any type
Delete | Table | To delete table
Delete any table | Table | To delete any table
Drop any sequence | Sequence | To drop any sequence
Drop any synonym | Synonym | To drop any synonym
Drop any table | Table | To drop any table
Drop any trigger | Trigger | To drop any trigger
Drop any type | Type | To drop any type
Execute | Function,Procedure,Package | To execute function, procedure,Package
Execute any function | Function | To execute any function
Execute any package | Package | To execute any package
Index | Table | To create index on table
Insert | Table | To insert into table
Insert any table | Table | To insert any table
References | Table | To have references on table
Select | Large object,Sequence,Table | To select on large object,sequence and table
Select any sequence | Sequence | To select any sequence
Select any table | Table | To select on any table
Temporary | Database | To create temporary table in database
Temp | Database | To create temporary table in database
Truncate | Table | To truncate table
Update | Large object,Sequence,Table | To update large object,Sequence,Table
Update any table | Table | To update any table
Usage | Domain,Foreign data wrapper,Foreign server,Language,Schema,Sequence,Type | To use domain,fdw,foreign server,language,schema,sequence and type
Vacuum | Table | To vacuum table
(42 rows)
