检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
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
FILTER_TYPE: 1 IP | APP | ROLES Parameters policy_name Specifies the audit policy name, which must be unique.
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.
That is, the system administrator can neither create roles or users, nor view or maintain database audit logs. In MySQL, administrator roles cannot be set for users, and there is no design for separation of duties.
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.
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?
That is, the system administrator can neither create roles or users, nor view or maintain database audit logs. In MySQL, administrator roles cannot be set for users, and there is no design for separation of duties.
You are advised to enable the audit logging function before using the function to record audit information. Calling this system function is a high-risk operation. Exercise caution when performing this operation.
You are advised to enable the audit logging function before using the function to record audit information. Calling this system function is a high-risk operation. Exercise caution when performing this operation.
The rule name in such a message indicates the throttling task ID on this page and the task ID in audit logs. Do not create tables with the same name.
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 columns.
Audit logs are not within the effective scope of the masking policies. In a masking policy, only one masking mode can be specified for a resource label.
Audit logs are not within the effective scope of the masking policies. In a masking policy, only one masking mode can be specified for a resource label.
FILTER_TYPE: 1 IP | APP | ROLES Parameters policy_name Specifies the audit policy name, which must be unique. Value range: a string.
AuditIndexFileLock Used to protect concurrent read and write of index files in the audit log. LWTRANCHE_ACCOUNT_TABLE Used to control the concurrent read and write of the hash table that stores the account locking status.
AuditIndexFileLock Used to protect concurrent read and write of index files in the audit log. SQLAdvisorLock Used to manage the concurrent access and storage of recommended hash tables in distribution key management.
