检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Synonyms cannot be created for encrypted tables that contain encrypted columns and views, functions, and stored procedures based on encrypted tables. A synonym can be associated with a package, but not with a function in a package.
Encrypted passwords are not supported. DEFAULT Resets the identifiers of the session and current users to the initially authenticated usernames.
| UNENCRYPTED ] PASSWORD { 'password' [EXPIRED] | DISABLE | EXPIRED } | [ ENCRYPTED | UNENCRYPTED ] IDENTIFIED BY { 'password' [ REPLACE 'old_password' | EXPIRED ] | DISABLE } | VALID BEGIN 'timestamp' | VALID UNTIL 'timestamp' | USER GROUP 'groupuser' |
| 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
Encrypted passwords are not supported. DEFAULT Resets the identifiers of the session and current users to the initially authenticated user names.
It is unavailable for other users. userepl boolean Whether the user has the permissions to duplicate data streams passwd text Encrypted user password.
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.
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
| 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
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.
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
Encrypted passwords are not supported. RESET ROLE Resets the current user identifier.
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.
It is unavailable for other users. t (true): yes. f (false): no. userepl boolean Whether the user has the permissions to duplicate data streams t (true): yes. f (false): no. passwd text Encrypted user password.
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
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.
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
