检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
for other users. t (true): yes f (false): no rolcanlogin boolean N/A Whether the role can log in to the database t (true): yes f (false): no rolreplication boolean N/A Whether the role can be replicated t (true): yes f (false): no rolauditadmin boolean N/A Whether the role is an audit
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, 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
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
FILTER_TYPE: 1 IP | APP | ROLES Parameters policy_name Specifies the audit policy name, which must be unique.
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 a role has the replication permission t (true): yes f (false): no rolauditadmin boolean 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
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
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
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
User-level audit settings The audit function is enhanced as follows: User-level audit is supported. The GUC parameter full_audit_users is added to set the list of audited users. Audit logs are recorded for all SQL statements executed by users in the list.
If the database is connected to the local PC, the value is empty. pg_query_audit Description: Views audit logs of the primary database node. Return type: record The following table describes return fields.
If a local connection is used, the value is empty. gs_query_audit(starttime, endtime, audit_log) Description: Queries the audit logs of the current CN. Parameters: timestamptz starttime and timestamptz endtime[,audit_log] Return type: record Table 1 describes the return columns.
