检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) Not supported.
The value –1 indicates no limit. rolpassword text N/A 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.
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) 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.
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) Not supported.
Its value is NULL. encrypted character varying(3) Not supported. Its value is NULL. compress_for character varying(30) Not supported. Its value is NULL. def_inmemory character varying(8) Not supported. Its value is NULL. def_inmemory_priority character varying(8) Not supported.
Unit: none 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 with SM3.
Parameter type: integer Unit: none 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 with
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.
Syntax CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause (optional) is as follows: {SYSADMIN | NOSYSADMIN} | {MONADMIN | NOMONADMIN} | {OPRADMIN
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.
Default value: postgresql enable_ce Specifies the encrypted equality query capability. Property type: integer Value range: 1: JDBC supports the basic capability of encrypted equality query. Other values: The basic capability of encrypted equality query is not supported.
Syntax 1 2 CREATE GROUP group_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [ EXPIRED ] | DISABLE }; The syntax of the option clause (optional) is as follows: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
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.
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
Default value: postgresql enable_ce Specifies the encrypted equality query capability. Property type: integer Value range: 1: JDBC supports the basic capability of encrypted equality query. Other values: The basic capability of encrypted equality query is not supported.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password. The value is displayed as ********. rolvalidbegin timestamp with time zone N/A Account validity start time.
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.
