检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
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.
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.
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.
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
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.
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.
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
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
- -k, --with-key=KEY Uses gsql to decrypt imported encrypted files.
- -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.
Whether the role has system administrator permissions t (true): yes f (false): no rolconnlimit integer Maximum number of concurrent connections that the role can make (valid for roles that can log in) The value –1 indicates there is no limit. rolpassword text Password (possibly encrypted
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
Compared with the PG driver, the GaussDB JDBC driver has the following enhanced features: SHA-256 is supported for encrypted login. The third-party log framework that implements the sf4j API can be connected. Distributed load balancing at the connection level is supported.
whether the role has the system administrator permission. t (true): yes f (false): no rolconnlimit integer Maximum number of concurrent connections that this role can make (valid for roles that can log in) The value –1 indicates there is no limit. rolpassword text Password (possibly encrypted
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.
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.
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.
