云数据库 GAUSSDB-ALTER ROLE:语法格式

时间:2024-11-13 14:46:50

语法格式

  • 修改角色的权限。
    1
    ALTER ROLE role_name [ [ WITH ] option [ ... ] ];
    

    • 其中权限项子句option为:
       1
       2
       3
       4
       5
       6
       7
       8
       9
      10
      11
      12
      13
      14
      15
      16
      17
      18
      19
      20
      21
      22
      23
      24
      25
      26
      {CREATEDB | NOCREATEDB}
          | {CREATEROLE | NOCREATEROLE}
          | {INHERIT | NOINHERIT}
          | {AUDITADMIN | NOAUDITADMIN}
          | {SYSADMIN | NOSYSADMIN}
          | {MONADMIN | NOMONADMIN}
          | {OPRADMIN | NOOPRADMIN}
          | {POLADMIN | NOPOLADMIN}
          | {USEFT | NOUSEFT}
          | { LOG IN | NOLOGIN}
          | {REPLICATION | NOREPLICATION}
         
          | {PERSISTENCE | NOPERSISTENCE}
          | CONNECTION LIMIT connlimit
          | [ ENCRYPTED | UNENCRYPTED ] PASSWORD { 'password' [EXPIRED] | DISABLE | EXPIRED }
          | [ ENCRYPTED | UNENCRYPTED ] IDENTIFIED BY { 'password' [ REPLACE 'old_password' | EXPIRED ] | DISABLE }
          | 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
          | ACCOUNT { LOCK | UNLOCK }
          | PGUSER
      

  • 修改角色的名称。
    1
    2
    ALTER ROLE role_name 
        RENAME TO new_name;
    

support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-0501.html