SHOW PRIVILEGES

功能描述

查看当前数据库中的权限信息清单。

注意事项

N/A

语法格式

1. SHOW PRIVILEGES

参数说明

N/A

示例

1. -- 显示当前数据库中的权限信息清单
2. opengauss=# show privileges;
3. Privileges      |                                                  Context                                                   |                              Comment
4. ----------------------+------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------
5. Alter                | Large object,Sequence,Database,Foreign Server,Function,Node group,Schema,Tablespace,Type,Directory,Package | To alter the 'objects'
6. Alter any index      | Index                                                                                                      | To alter any index
7. Alter any sequence   | Sequence                                                                                                   | To alter any sequence
8. Alter any table      | Table                                                                                                      | To alter any table
9. Alter any trigger    | Trigger                                                                                                    | To alter any trigger
10. Alter any type       | Type                                                                                                       | To alter any type
11. Comment              | Table                                                                                                      | To comment on table
12. Compute              | Node group                                                                                                 | To compute on node group
13. Connect              | Database                                                                                                   | To connect database
14. Create               | Database,Schema,Tablespace,Node group                                                                      | To create database,schema,tablespace,node group
15. Create any function  | Function                                                                                                   | To create any function
16. Create any index     | Index                                                                                                      | To create any index
17. Create any package   | Package                                                                                                    | To create any package
18. Create any sequence  | Sequence                                                                                                   | To create any sequence
19. Create any synonym   | Synonym                                                                                                    | To create any synonym
20. Create any table     | Table                                                                                                      | To create any table
21. Create any trigger   | Trigger                                                                                                    | To create any trigger
22. Create any type      | Type                                                                                                       | To create any type
23. Delete                | Table                                                                                                      | To delete table
24. Delete any table      | Table                                                                                                      | To delete any table
25. Drop any sequence    | Sequence                                                                                                   | To drop any sequence
26. Drop any synonym     | Synonym                                                                                                    | To drop any synonym
27. Drop any table       | Table                                                                                                      | To drop any table
28. Drop any trigger     | Trigger                                                                                                    | To drop any trigger
29. Drop any type        | Type                                                                                                       | To drop any type
30. Execute              | Function,Procedure,Package                                                                                 | To execute function, procedure,Package
31. Execute any function | Function                                                                                                   | To execute any function
32. Execute any package  | Package                                                                                                    | To execute any package
33. Index                | Table                                                                                                      | To create index on table
34. Insert               | Table                                                                                                      | To insert into table
35. Insert any table     | Table                                                                                                      | To insert any table
36. References           | Table                                                                                                      | To have references on table
37. Select               | Large object,Sequence,Table                                                                                | To select on large object,sequence and table
38. Select any sequence  | Sequence                                                                                                   | To select any sequence
39. Select any table     | Table                                                                                                      | To select on any table
40. Temporary            | Database                                                                                                   | To create temporary table in database
41. Temp                 | Database                                                                                                   | To create temporary table in database
42. Truncate             | Table                                                                                                      | To truncate table
43. Update               | Large object,Sequence,Table                                                                                | To update large object,Sequence,Table
44. Update any table     | Table                                                                                                      | To update any table
45. Usage                | Domain,Foreign data wrapper,Foreign server,Language,Schema,Sequence,Type                                   | To use domain,fdw,foreign server,language,schema,sequence and type
46. Vacuum               | Table                                                                                                      | To vacuum table
47. (42 rows)