检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
boolean Whether a role can log in, that is, whether a role can be given as the initial session authorization identifier. rolreplication boolean Indicates that the role is a replicated one (an adaptation syntax and no actual meaning). rolauditadmin boolean Indicates that the role is an audit
boolean Whether a role can log in, that is, whether a role can be given as the initial session authorization identifier. rolreplication boolean Indicates that the role is a replicated one (an adaptation syntax and no actual meaning). rolauditadmin boolean Indicates that the role is an audit
Viewing Audit Logs to Check the Users Who Have Modified Service Data Database audit logs record users' daily activities, including accessing and modifying service data.
The pg_query_audit_details() function is added for viewing audit logs and parsing the object_name and object_details fields in audit logs from the JSON format.
In addition, detail_info is used to store the command execution results instead of commands, which have been moved to command_text. 68 login_audit_messages Enhanced the audit log feature.
generation 223 Plan Cache 224 Analyze 225 utile Interface 226 Actuator Row Execution Engine 231 Vectorized Execution Engine 232 Executing Diagnostic Information 233 LLVM 234 Distributed Framework 235 RemoteQuery 236 Explain 237 Security Certificates 241 Authorizes 242 Encryptes 243 Audit
However, do not grant user1 the system administrator and audit administrator permissions, and do not limit the number of connections.
After the audit process is enabled, it can read the auditing information written by the background process from the pipe and save it into audit files. on or off audit_space_limit Maximum storage space occupied by audit files, in KB. 1,024–1,073,741,824 autoanalyze Whether to allow
AUDITADMIN | NOAUDITADMIN Determines whether a role has the audit and management attributes. The default value is NOAUDITADMIN. CREATEDB | NOCREATEDB Defines a role's ability to create databases. A new role does not have the permission to create databases.
Use the pgxc_query_audit function to query audit logs of all CNs.
Audit logs can record objects that are deleted in cascading mode. Audit logs can be dumped to OBS. Ecosystem compatibility if not exists can be included in the create schema, create index, and create sequence statements.
2 Response body parameter Parameter Type Description name String Username. login Boolean Permission to log in to the database createrole Boolean Permission to create roles createdb Boolean Permission to create databases systemadmin Boolean System administrator auditadmin Boolean Audit
Modify 14 audit_system_object The 18th digit is added to indicate whether to audit SYNONYM objects.
To mitigate this risk, disable audit log dump while performing the change.
AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit and management attributes. If not specified, NOAUDITADMIN is the default. SYSADMIN | NOSYSADMIN Determines whether a new user is a system administrator. Users with the SYSADMIN attribute have the highest permission.
- AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit administrator attribute. If not specified, NOAUDITADMIN is the default value. - SYSADMIN | NOSYSADMIN Determines whether a new user is a system administrator.
- AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit administrator attribute. If not specified, NOAUDITADMIN is the default. - CREATEDB | NOCREATEDB Determines whether a new user can create a database. Value range: If not specified, NOCREATEDB is the default.
AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit administrator attribute. If not specified, NOAUDITADMIN is the default. CREATEDB | NOCREATEDB Determines whether a new user can create a database.
AUDITADMIN | NOAUDITADMIN Determines whether a role has the audit and management attributes. If not specified, NOAUDITADMIN is the default. CREATEDB | NOCREATEDB Defines a role's ability to create databases. A new role does not have the permission to create databases.
- AUDITADMIN | NOAUDITADMIN Determines whether a role has the audit and management attributes. If not specified, NOAUDITADMIN is the default. - SYSADMIN | NOSYSADMIN Determines whether a new role is a system administrator.
