SPD Server supports
SQL audit logging of submitted SQL queries and proxy auditing of access
to SPD Server resources. SPD Server proxy auditing and SQL audit logging
(spdsaud) are enabled when the server is started using the -AUDITFILE
or -SQLAUDITFILE parameters. You can enable proxy auditing or SQL
audit logging, or both.
For more information about start-up options, see the Help
section in the SPD Server Administrator's Guide on SPD Server Host Commands .
SPD Server auditing
provides a way to log access to SPD Server resources, or to log implicit
or explicit SQL pass-through queries that are submitted to SPD Server.
Separate audit logs are created for proxy auditing and SQL audit logging.
SPD Server includes three SAS programs (auditwithwhere.sas, auditraw.sas,
and auditsql.sas) in the /samples directory of your SPD Server installation.
These programs enable you to input the audit logs into SAS tables.
Then, you can query the SAS tables to determine access to SPD Server
tables and resources.