云数据库 GaussDB-CREATE GROUP:语法格式

时间：2025-02-12 15:06:01

云数据库 GaussDB

语法格式

  
       CREATE GROUP group_name [ [ WITH ] option [ ... ] ]     [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE };

其中可选项action子句语法为：

  
       {SYSADMIN | NOSYSADMIN}    | {MONADMIN | NOMONADMIN}    | {OPRADMIN | NOOPRADMIN}    | {POLADMIN | NOPOLADMIN}    | {AUDITADMIN | NOAUDITADMIN}    | {CREATEDB | NOCREATEDB}    | {USEFT | NOUSEFT}    | {CREATEROLE | NOCREATEROLE}    | {INHERIT | NOINHERIT}    | { LOG IN | NOLOGIN}    | {REPLICATION | NOREPLICATION}    | {VCADMIN | NOVCADMIN}    | {PERSISTENCE | NOPERSISTENCE}    | CONNECTION LIMIT connlimit    | VALID BEGIN 'timestamp'    | VALID UNTIL 'timestamp'        | USER GROUP 'groupuser'    | PERM SPACE 'spacelimit'    | NODE GROUP logic_group_name    | IN ROLE role_name [, ...]    | IN GROUP role_name [, ...]    | ROLE role_name [, ...]    | ADMIN role_name [, ...]    | USER role_name [, ...]    | SYSID uid    | DEFAULT TABLESPACE tablespace_name    | PROFILE DEFAULT    | PROFILE profile_name    | PGUSER