Auditing options

Following are updates to Table 2 in section 1.9.1 of New Features Adaptive Server® Enterprise 12.5.3a.

Table 3: Auditing options, requirements, and examples

Options

login_name

object_name

Database to be in to set the option

Command being audited

encryption_key

(database-specific)

all

Database to be audited

Any

alter encryption key

create encryption key

drop encryption key

sp_encryption

Example Audits all the above commands in the pubs2 database:

sp_audit "encryption_key", "all", "pubs2", "on"