检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
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.
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.
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.
updated": "2022-04-11 10:46:59", "datastore_version": "2.0", "datastore_name": "GaussDB", "configuration_parameters": [ { "name": "audit_system_object", "value": "12295", "type": "integer", "description": "Whether to audit
This parameter has an impact on viewing audit results, GS_SESSION_MEMORY_DETAIL, PG_STAT_ACTIVITY, and the GUC parameter log_line_prefix. Table 2 describes the preceding parameter levels.
that is, whether the role can be given as the initial session authorization identifier. t (true): yes f (false): no rolreplication Boolean Specifies whether the role has the replication permission. t (true): yes f (false): no rolauditadmin Boolean Specifies whether the role has the audit
that is, whether the role can be given as the initial session authorization identifier. t (true): yes f (false): no rolreplication boolean Specifies whether the role has the replication permission. t (true): yes f (false): no rolauditadmin boolean Specifies whether the role has the audit
This parameter has an impact on viewing audit results, PG_STAT_ACTIVITY, and the GUC parameter log_line_prefix. Table 2 describes the parameter levels of Table 1.
(false): no rolcanlogin boolean N/A Specifies whether the role can log in to the database. t (true): yes f (false): no rolreplication boolean N/A Specifies whether the role can be replicated. t (true): yes f (false): no rolauditadmin boolean N/A Specifies whether the role is an 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.
FILTER_TYPE: 1 IP | APP | ROLES Parameters policy_name Specifies the audit policy name, which must be unique.
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.
This parameter has an impact on viewing audit results, GS_SESSION_MEMORY_DETAIL, PG_STAT_ACTIVITY, and the GUC parameter log_line_prefix. Table 2 describes the preceding parameter levels.
This parameter has an impact on viewing audit results, PG_STAT_ACTIVITY, and the GUC parameter log_line_prefix. Table 2 describes the preceding parameter levels.
in (whether this role can be given as the initial session authorization identifier) t (true): yes f (false): no rolreplication boolean Specifies whether the role has the replication permission. t (true): yes f (false): no rolauditadmin boolean Specifies whether the role has the audit
false): no. rolcanlogin boolean N/A Specifies whether the role can log in to the database. t (true): yes. f (false): no. rolreplication boolean N/A Specifies whether the role can be replicated. t (true): yes. f (false): no. rolauditadmin boolean N/A Specifies whether the role is an audit
