ob_enable_sql_audit

Description

ob_enable_sql_audit specifies whether to enable the SQL audit feature for the current tenant.

Privilege requirements

• Query variables

  sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle-compatible mode) or the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode) to obtain the value of a global system variable.

• Modify variables

  • sys tenants can directly modify the value of a global system variable.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.

Attributes

Syntax

enable_sql_audit specifies whether to enable the SQL audit feature for all tenants. If the value is false, the SQL audit feature is disabled for all tenants.

Examples

Set the value of ob_enable_sql_audit to true to enable the SQL audit feature for the current tenant.

obclient> SET GLOBAL ob_enable_sql_audit =true;