检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Encrypted passwords are not supported. RESET ROLE Resets the current user identifier.
Functions and Operators Text Search Functions and Operators JSON/JSONB Functions and Operators HLL Functions and Operators SEQUENCE Functions Array Functions and Operators Range Functions and Operators Aggregate Functions Window Functions Security Functions Ledger Database Functions Encrypted
SSL It provides encrypted transmission. Data is protected during transmission, ensuring high security. It supports client/server identity authentication, which enhances security. It is complex in configuration and management, and certificates need to be issued and updated.
Encrypted passwords are not supported.
Encrypted passwords are not supported.
Value range: 0, 1, 2, or 3 0 indicates that passwords are encrypted with MD5. 1 indicates that passwords are encrypted with SHA-256 and MD5. 2 indicates that passwords are encrypted with SHA-256. 3 indicates that the passwords are encrypted in sm3 mode.
Encrypted passwords are not supported. RESET ROLE Resets the current user identifier.
Syntax CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause is as follows: {SYSADMIN | NOSYSADMIN} | {MONADMIN | NOMONADMIN} | {OPRADMIN | NOOPRADMIN
SSL It provides encrypted transmission. Data is protected during transmission, ensuring high security. It supports client/server identity authentication, which enhances security. It is complex in configuration and management, and certificates need to be issued and updated.
Value range: 0, 1, 2, or 3 0 indicates that passwords are encrypted with MD5. 1 indicates that passwords are encrypted with SHA-256 and MD5. 2 indicates that passwords are encrypted with SHA-256. 3 indicates that the passwords are encrypted in sm3 mode.
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
Table 1 SQL statements for defining a CMK Function SQL Statement Creating a CMK CREATE CLIENT MASTER KEY Deleting a CMK DROP CLIENT MASTER KEY Defining a CEK CEKs are used to encrypt data for the encrypted database feature.
| 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
| 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
This permission is unavailable for other users. t (true): yes. f (false): no. userepl boolean Specifies whether the user has the permissions to duplicate data streams. t (true): yes. f (false): no. passwd text Encrypted user password.
Syntax CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause is as follows: {SYSADMIN | NOSYSADMIN} | {MONADMIN | NOMONADMIN} | {OPRADMIN | NOOPRADMIN
Syntax 1 2 CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the optional action clause is as follows: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
This permission is unavailable for other users. t (true): yes. f (false): no. userepl Boolean Specifies whether the user has the permissions to duplicate data streams. t (true): yes. f (false): no. passwd text Encrypted user password.
This permission is unavailable for other users. t (true): yes f (false): no userepl boolean Specifies whether the user has the permissions to duplicate data streams. t (true): yes f (false): no passwd text Encrypted user password.
This permission is unavailable for other users. t (true): yes. f (false): no. userepl boolean Specifies whether the user has the permissions to duplicate data streams. t (true): yes. f (false): no. passwd text Encrypted user password.
