sa_disable_auditing_type system procedure

Syntax

sa_disable_auditing_type(' types ')

Arguments

• types – Use this VARCHAR(128) parameter to specify a comma-delimited string containing one or more of the following values:
  • all – disables all types of auditing.
  • connect – disables auditing of both successful and failed connection attempts.
  • connectFailed – disables auditing of failed connection attempts.
  • DDL – disables auditing of DDL statements.
  • options – disables auditing of public options.
  • permission – disables auditing of permission checks, user checks, and SETUSER statements.
  • permissionDenied – disables auditing of failed permission and user checks.
  • triggers – disables auditing in response to trigger events.

Remarks

You can use the sa_disable_auditing_type system procedure to disable auditing of one or more categories of information.

Setting this option to all disables all auditing. You can also disable auditing by setting the PUBLIC.auditing option to Off.

Permissions

DBA authority

Side effects

None

Example

To disable all auditing:

CALL sa_disable_auditing_type( 'all' );