检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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.
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
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
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.
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.
User passwords are encrypted and stored in the system catalog PG_USER_MAPPING. During the encryption, usermapping.key.cipher and usermapping.key.rand are used as the encryption password file and encryption factor.
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.
For details, see "Setting Encrypted Equality Queries" in Feature Guide. Helpful Links ALTER COLUMN ENCRYPTION KEY and DROP COLUMN ENCRYPTION KEY Parent topic: SQL Syntax
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
For details, see "Setting Encrypted Equality Queries" in Feature Guide. Helpful Links ALTER COLUMN ENCRYPTION KEY and DROP COLUMN ENCRYPTION KEY Parent topic: SQL Syntax
Operators Network Address 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 Encrypted
Set it to NULL. encrypted character varying(3) Not supported. Set it to NULL. compress_for character varying(30) Not supported. Set it to NULL. def_inmemory character varying(8) Not supported. Set it to NULL. def_inmemory_priority character varying(8) Not supported.
It is unavailable for other users. t (true): yes. f (false): no. userepl Boolean Specifies whether this 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.
The value is NULL. encrypted character varying(3) Not supported. The value is NULL. compress_for character varying(30) Not supported. The value is NULL. def_inmemory character varying(8) Not supported. The value is NULL. def_inmemory_priority character varying(8) Not supported.
