检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
C CALL CHECKPOINT CLEAN CONNECTION CLOSE CLUSTER COMMENT COMMIT | END COMMIT PREPARED COPY CREATE AGGREGATE CREATE AUDIT POLICY CREATE CAST CREATE CLIENT MASTER KEY CREATE COLUMN ENCRYPTION KEY CREATE CONVERSION CREATE DATABASE CREATE DATABASE LINK CREATE DIRECTORY CREATE EVENT CREATE
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.
How Do I Enable the Audit of INSERT, UPDATE, and DELETE Operations in GaussDB? How Do I Set the Maximum Number of WAL Sender Threads That Can Be Created in GaussDB? How Do I Set the Maximum Number of Bytes to Be Logged for Each SQL Statement in GaussDB?
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
Constraints N/A Range audit_log: audit log Default Value N/A Response Parameters Table 5 Response parameters Parameter Type Description job_id String Definition ID of the job for creating an instance.
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.
FILTER_TYPE: 1 IP | APP | ROLES Parameters policy_name Specifies the audit policy name, which must be unique.
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
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.
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 parameter log_line_prefix. Table 2 describes the preceding parameter levels.
(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
