检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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. DR failover is supported.
Precautions Currently, you can change only the permissions for tables (including views), sequences, functions, client master keys of encrypted databases, column encryption keys, and types.
Precautions Currently, you can change only the permissions for tables (including views), sequences, functions, types, CMKs of encrypted databases, and CEKs.
COLUMN_ENCRYPTION_KEY = column_encryption_key Specifies the name of the column encryption key in the ENCRYPTED WITH constraint. Value range: a string. It must comply with the Identifier Naming Conventions.
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. DR failover is supported.
Precautions Currently, you can change only the permissions for tables (including views), sequences, functions, types, client master keys of encrypted databases, and column encryption keys.
table. 1 2 3 4 5 6 7 8 openGauss=# SET SESSION AUTHORIZATION newuser PASSWORD 'xxxxxxxxx'; openGauss=> CREATE TABLE acltest1 (x int, x2 varchar(50) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = MyCEK1, ENCRYPTION_TYPE = DETERMINISTIC)); CREATE TABLE openGauss=> SELECT has_cek_privilege
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.
The following object types do not support flashback: system catalogs, DFS tables, global temporary tables, local temporary tables, unlogged tables, sequence tables, encrypted tables, and hash bucket tables. Flashback is not supported for tables that contain user-defined types.
The following object types do not support flashback: system catalogs, DFS tables, global temporary tables, local temporary tables, unlogged tables, sequence tables, encrypted tables, and hash bucket tables. Flashback is not supported for tables that contain user-defined types.
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. DR failover is supported.
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. DR failover is supported.
Use gsql to execute them to restore databases. gs_dumpall supports SSL encrypted communication. The method is the same as that of using gsql.
Use gsql to execute them to restore cluster databases. gs_dumpall supports SSL encrypted communication. The method is the same as that of using gsql.
table. 1 2 3 4 5 6 7 8 9 10 openGauss=# SET SESSION AUTHORIZATION newuser PASSWORD 'xxxxxxxxx'; openGauss=> CREATE TABLE acltest1 (x int, x2 varchar(50) ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = MyCEK1, ENCRYPTION_TYPE = DETERMINISTIC)); NOTICE: The 'DISTRIBUTE BY' clause
are encrypted using SM3.
--with-encryption=AES128 Specifies that dumping data needs to be encrypted using AES-128. --with-key=KEY The AES-128 key rules are as follows: Consists of 8 to 16 characters.
Unit: none Value range: on: The SSL certificate is enabled for encrypted communication. off: The SSL certificate is disabled for encrypted communication. Default value: off Setting method: This parameter is a CM parameter.
Default value: 10 (financial edition (data computing)) hadr_super_user_record_path Parameter description: Specifies the path for storing encrypted files of the hadr_disaster user in the standby cluster in streaming DR mode. This is a SIGHUP parameter.
Syntax 1 CREATE USER user_name [ [ WITH ] option [ ... ] ] [ ENCRYPTED | UNENCRYPTED ] { PASSWORD | IDENTIFIED BY } { 'password' [EXPIRED] | DISABLE }; The option clause is used to configure information, including permissions and properties. 1 2 3 4 5 6 7 8 9 10 11 12 13
