Auditing options

The following table is excerpted from Adaptive Server System Administration Guide and shows the new commands audited with existing event options and the new event options.

Table 30-2: Auditing options, requirements, and examples

Options

login_name

object_name

Database to be in to set the option

Command or access being audited

encryption_key

(database-specific)

all

Database to be audited

Any

alter encryption key

create encryption key

drop encryption key

create table

drop table

alter table

sp_encryption

Example sp_audit “encryption_key”, “all”, “pubs2”, “on”

(Audits all the above commands in the pubs2 database.)