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)