检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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.
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
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.
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.
Default value: NOSYSADMIN AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit administrator attribute. Default value: NOAUDITADMIN CREATEDB | NOCREATEDB Controls whether a new user can create a database.
- AUDITADMIN | NOAUDITADMIN Defines whether a user has the audit administrator attribute. Default value: NOAUDITADMIN SYSADMIN | NOSYSADMIN Controls whether a user is a system administrator. A user with the SYSADMIN attribute has the highest permission in the system.
- 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.
AUDITADMIN Allows you to view audit logs. LOGIN Allows you to connect to databases. System permissions are generally specified using CREATE ROLE or ALTER ROLE syntax.
The CPU monitoring logic is changed from Cgroup monitoring to job CPU monitoring summary. 5 Audit logs Statements in a transaction are audited when the statement type is set to be audited, even if the transaction is not set to be audited.