Contents Index sa_db_properties system procedure sa_disk_free_space system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_disable_auditing_type


Function 

Disables auditing of specific events.

Syntax 

sa_disable_auditing_type ( [ string ] )

Parameters 

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

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.

Permissions 

DBA authority required

Side effects 

None

Description 

You can use the sa_disable_auditing_type option 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.


Contents Index sa_db_properties system procedure sa_disk_free_space system procedure