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

时间：2023-11-01 16:22:10

云数据库 GaussDB

语法格式

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

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

{SYSADMIN | NOSYSADMIN}    | {MONADMIN | NOMONADMIN}    | {OPRADMIN | NOOPRADMIN}    | {POLADMIN | NOPOLADMIN}    | {AUDITADMIN | NOAUDITADMIN}    | {CREATEDB | NOCREATEDB}    | {USEFT | NOUSEFT}    | {CREATEROLE | NOCREATEROLE}    | {INHERIT | NOINHERIT}    | { LOG IN | NOLOGIN}    | {REPLICATION | NOREPLICATION}    | {INDEPENDENT | NOINDEPENDENT}    | {VCADMIN | NOVCADMIN}    | {PERSISTENCE | NOPERSISTENCE}    | 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

上一篇：云数据库 GaussDB-CREATE ROLE:示例

下一篇：云数据库 GaussDB-CREATE ROLE:示例