Contents Index sa_disk_free_space system procedure sa_eng_properties system procedure

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

sa_enable_auditing_type


Function 

Enables auditing and specifies which events to audit.

Syntax 

sa_enable_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

Side effects 

None

Description 

Sa_enable_auditing_type works in conjunction with the public.auditing option to enable auditing of specific types of information.

If you set the public.auditing option to ON, and do not specify which type of information to audit, the default setting (all) takes effect. In this case, all types of auditing information are recorded.

If you set the public.auditing option to ON, and disable all types of auditing using sa_disable_auditing_type, no auditing information is recorded. In order to re-establish auditing, you must use sa_enable_auditing_type to specify which type of information you want to audit.

If you set the public.auditing option to OFF, then no auditing information is recorded, regardless of the sa_enable_auditing_type setting.

Example 

To enable only option auditing:

sa_disable_auditing_type('all')
sa_enable_auditing_type('options')

Contents Index sa_disk_free_space system procedure sa_eng_properties system procedure