sysauditoptions

sybsecurity database

Description

sysauditoptions contains one row for each server-wide audit option and indicates the current setting for that option. Other types of auditing option settings are stored in other tables. For example, database-specific option settings are stored in sysdatabases, and object-specific option settings are stored in sysobjects. The default value for each option is 0, or “off.” Only System Security Officers can access sysauditoptions.

Columns

The columns for sysauditoptions are:

Name

Datatype

Description

num

smallint

Number of the server-wide option.

val

smallint

Current value; one of the following:

  • 0 = off

  • 1 = pass

  • 2 = fail

  • 3 = on

minval

smallint

Minimum valid value for this option.

maxval

smallint

Maximum valid value for this option.

name

varchar(30)

Name of option.

sval

varchar(30)

String equivalent of the current value: for example, “on”, “off”, “nonfatal”.

comment

varchar(255)

Description of option.