检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Whether the role has 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
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
The value –1 indicates there is no limit. rolpassword text Password (possibly encrypted); NULL if no password rolvalidbegin timestamp with time zone Account validity start time (NULL if no start time). rolvaliduntil timestamp with time zone Password expiry time (NULL if no expiration
Currently, encrypted databases are not supported. If no IP address is specified, this parameter is left empty by default. port: specifies the port number for connection.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
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.
The value –1 indicates no limit. rolpassword text N/A Encrypted user password.
If SSL is used for encrypted transmission, use the gsfss protocol. In this case, the location is gsfss://192.168.0.90:5000/*. FORMAT CSV Format of source data files. ENCODING UTF-8 Data encoding format. DELIMITER It is set to a comma (,). Field separator.
Table-level restoration does not support segment-page tables, column-store tables, tables containing user-defined types, synonym tables, temporary tables (including global tables), encrypted tables, TDE-enabled tables, unlogged tables, compressed tables, tables of private users, and
Currently, encrypted databases are not supported. If no IP address is specified, this parameter is left empty by default. port: specifies the port number for connection.
System catalogs, DFS tables, global temporary tables, local temporary tables, unlogged tables, sequence tables, encrypted tables, and hash bucket tables Objects in the recycle bin are cleared and do not support DROP or TRUNCATE FLASHBACK.
System catalogs, DFS tables, global temporary tables, local temporary tables, unlogged tables, sequence tables, encrypted tables, and hash bucket tables Objects in the recycle bin are cleared and do not support DROP or TRUNCATE FLASHBACK.
Syntax 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.
Syntax 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.
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
Default value: postgresql enable_ce Specifies the encrypted equality query capability.
To enable the encrypted equality query, set this parameter to 1 or 3. key_info This parameter is used together with enable_ce to set parameters for accessing an external key manager in an encrypted database. connection_info The value of connection_info is a JSON character string consisting
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
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
