sa_disable_auditing_type system procedure

Function

Disables auditing of specific events.

Syntax

sa_disable_auditing_type( ['string ] )

Parameters

string is a comma-delimited string containing one or more of:

all enables all types of auditing.

connect enables auditing of both successful and failed connection attempts.

connectFailed enables auditing of failed connection attempts.

DDL enables auditing of DDL statements.

options enables auditing of public options.

permission enables auditing of permission checks, user checks, and setuser statements.

permissionDenied enables auditing of failed permission and user checks.

triggers enables auditing after a trigger event.

Permissions

DBA authority required.

Description

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.