数据仓库服务 GaussDB(DWS)-CREATE ROLE:语法格式

时间：2025-02-12 15:04:42

语法格式

  
       CREATE ROLE role_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' | DISABLE };

其中角色信息设置子句option语法为：

   
        {SYSADMIN | NOSYSADMIN}    | {AUDITADMIN | NOAUDITADMIN}    | {CREATEDB | NOCREATEDB}    | {USEFT | NOUSEFT}    | {CREATEROLE | NOCREATEROLE}    | {INHERIT | NOINHERIT}    | { LOG IN | NOLOGIN}    | {REPLICATION | NOREPLICATION}    | {INDEPENDENT | NOINDEPENDENT}    | {VCADMIN | NOVCADMIN}    | CONNECTION LIMIT connlimit    | VALID BEGIN 'timestamp'    | VALID UNTIL 'timestamp'    | RESOURCE POOL 'respool'    | USER GROUP 'groupuser'    | PERM SPACE 'spacelimit'    | TEMP SPACE 'tmpspacelimit'    | SPILL SPACE 'spillspacelimit'    | NODE GROUP logic_cluster_name    | IN ROLE role_name [, ...]    | IN GROUP role_name [, ...]    | ROLE role_name [, ...]    | ADMIN rol e_name [, ...]    | USER role_name [, ...]    | SYSID uid    | DEFAULT TABLESPACE tablespace_name    | PROFILE DEFAULT    | PROFILE profile_name    | PGUSER    | AUTHINFO 'authinfo'    | PASSWORD EXPIRATION period