检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Users with the audit administrator permission can query this system catalog, but no user is allowed to modify this system catalog.
Users with the audit administrator permission can query this system catalog, but no user is allowed to modify this system catalog.
gaussdb=# SELECT ledger_hist_repair('ledgernsp','tab'); ledger_hist_repair -------------------- 0000000000000000 (1 row) ledger_hist_archive(text, text) Description: Archives the history table corresponding to a specified tamper-proof user table to the hist_back folder in the audit
Results. pg_delete_audit Description: Deletes audit logs in a specified period.
gaussdb=# SELECT ledger_hist_repair('ledgernsp','tab'); ledger_hist_repair -------------------- 0000000000000000 (1 row) ledger_hist_archive(text, text) Description: Archives the history table corresponding to a specified tamper-proof user table to the hist_back folder in the audit
When the audit function is enabled, you can search for the creation statement in the audit log.
It is unavailable for other users. rolcanlogin boolean - Whether the role can log in to the database rolreplication boolean - Whether the role can be replicated rolauditadmin boolean - Whether the role is an audit system administrator rolsystemadmin boolean - Whether the role is a
Astore does not support rollback segments. 10 Tablespaces Supported. 11 Tablespace sets Not supported. 12 Unified audit policies Supported. 13 Users Supported. Parent topic: Basic SQL Elements
Astore does not support rollback segments. 10 Tablespaces Supported. 11 Tablespace sets Not supported. 12 Unified audit policies Supported. 13 Users Supported. Parent topic: Basic SQL Elements
Return type: record The return fields of this function are the same as those of the pg_query_audit function. pg_delete_audit Description: Deletes audit logs in a specified period.
Return type: record The return fields of this function are the same as those of the pg_query_audit function. pg_delete_audit(timestamp startime,timestamp endtime) Description: Deletes audit logs in a specified period.
Audit logs contain transaction IDs, which are used to associate data changes with audit operations. The password of the O&M account is encrypted and flushed to disks.
Operations performed by users in the INDEPENDENT role are recorded in audit logs based on the audit policy. VCADMIN | NOVCADMIN Defines the role of a logical cluster administrator.
Security Policy Administrator A security policy administrator is an account with the POLADMIN attribute and has the permission to create resource tags, masking policies, and unified audit policies.
]* FILTER_TYPE: 1 IP | APP | ROLES Parameter Description policy_name Specifies the audit policy name, which must be unique. Value range: a string.
]* FILTER_TYPE: 1 IP | APP | ROLES Parameter Description policy_name Specifies the audit policy name, which must be unique. Value range: a string.
Whether the role can log in (whether this role can be given as the initial session authorization identifier) t (true): yes f (false): no rolreplication boolean Whether the role has the replication permission t (true): yes f (false): no rolauditadmin boolean Whether the role has the audit
This parameter has an impact on viewing audit results, GS_SESSION_MEMORY_DETAIL, PG_STAT_ACTIVITY, and the parameter log_line_prefix. Table 2 describes the preceding parameter levels.
Security Policy Administrator A security policy administrator is an account with the POLADMIN attribute and has the permission to create resource tags, masking policies, and unified audit policies.
This parameter has an impact on viewing audit results, PG_STAT_ACTIVITY, and the parameter log_line_prefix. Table 2 describes the preceding parameter levels.
