sybsecurity database
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.
The columns for sysauditoptions are:
Name |
Datatype |
Description |
|---|---|---|
num |
smallint |
Number of the server-wide option. |
val |
smallint |
Current value; one of the following:
|
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. |
