• Read permissions that were granted to an SPD Server user to access a resource
• Write permissions that were granted to an SPD Server user while accessing a resource
• the ACLs that are associated with a resource
WHERE Clause Auditing
WHERE clause auditing provides an audit record that contains the following information:
• the length of the WHERE clause
• the contents of the WHERE clause
WHERE clause auditing is enabled using the WHEREAUDIT option. The maximum size
that can be allocated WHERE clauses is controlled by the WHAUDLEN option. For more
information, see “SPD Server Parameter File Configurations for Auditing” on page 120.
SQL Query Auditing
SQL audit logging provides a record of the SQL queries that were submitted to the SPD
Server server. The SQL audit record contains the following information:
• the SQL query timestamp
• the type of SQL query
• SELECT
• DROP
• ALTER
• CREATE
• DESCRIBE
• UPDATE
• DELETE
• RESET
• BEGIN ASYNC
• END ASYNC
• the number of rows that were returned for an SQL SELECT statement
• the elapsed time in seconds required to process the SQL query
• the user ID of the SPD Server user that submitted the query
• the group ID of the SPD Server user that submitted the query
• the default LIBNAME for the query, used for any table that is not referenced by a two
part name
• the length of the query in characters
• the text of the submitted SQL query
The maximum size that can be allocated in the SQL log for an SQL statement is controlled
by the SQLAUDLEN option. For more information, see “SPD Server Parameter File
Configurations for Auditing” on page 120.
SQL Query Auditing 191
