DB2 10.5 for Linux, UNIX, and Windows

CHECKING access attempted types

The following list shows the possible CHECKING access attempted types.

If Audit Event is CHECKING_TRANSFER, then the audit entry reflects that a privilege is held or not.
0x00000000000000000000000000000001 CONTROL
Attempt to verify whether CONTROL privilege is held.
0x00000000000000000000000000000002 ALTER
Attempt to alter an object or to verify whether ALTER privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000004 DELETE
Attempt to delete an object or to verify whether DELETE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000008 INDEX
Attempt to use an index or to verify whether INDEX privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000010 INSERT
Attempt to insert into an object or to verify whether INSERT privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000020 SELECT
Attempt to query a table or view or to verify whether SELECT privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000040 UPDATE
Attempt to update data in an object or to verify whether UPDATE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000080 REFERENCE
Attempt to establish referential constraints between objects or to verify whether REFERENCE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000000100 CREATE
Attempt to create an object.
0x00000000000000000000000000000200 DROP
Attempt to drop an object.
0x00000000000000000000000000000400 CREATEIN
Attempt to create an object within another schema.
0x00000000000000000000000000000800 DROPIN
Attempt to drop an object found within another schema.
0x00000000000000000000000000001000 ALTERIN
Attempt to alter or modify an object found within another schema.
0x00000000000000000000000000002000 EXECUTE
Attempt to execute or run an application or to invoke a routine, create a function sourced from the routine (applies to functions only), or reference a routine in any DDL statement or to verify whether EXECUTE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000000004000 BIND
Attempt to bind or prepare an application.
0x00000000000000000000000000008000 SET_EVENT MONITOR
Attempt to set event monitor switches.
0x00000000000000000000000000010000 SET_CONSTRAINTS
Attempt to set constraints on an object.
0x00000000000000000000000000020000 COMMENT ON
Attempt to create comments on an object.
0x00000000000000000000000000040000 GRANT
Attempt to grant privileges or roles on an object to another authorization ID.
0x00000000000000000000000000080000 REVOKE
Attempt to revoke privileges or roles from an object from an authorization ID.
0x00000000000000000000000000100000 LOCK
Attempt to lock an object.
0x00000000000000000000000000200000 RENAME
Attempt to rename an object.
0x00000000000000000000000000400000 CONNECT
Attempt to connect to a database.
0x00000000000000000000000000800000 MEMBER_OF_SYS_GROUP
Attempt to access or use a member of the SYS group.
0x00000000000000000000000001000000 ALL
Attempt to execute a statement with all required privileges on objects held (only used for DBADM/SYSADM).
0x00000000000000000000000002000000 DROP ALL
Attempt to drop multiple objects.
0x00000000000000000000000004000000 LOAD
Attempt to load a table in a table space.
0x00000000000000000000000008000000 USE
Attempt to create a table in a table space or to verify whether USE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000000010000000 SET_SESSION_USER
Attempt to execute the SET SESSION_USER statement.
0x00000000000000000000000020000000 FLUSH
Attempt to execute the FLUSH statement.
0x00000000000000000000000040000000 STORE
Attempt to view the values of a reoptimized statement in the EXPLAIN_PREDICATE table.
0x00000000000000000000000100000000 SET_OWNER
Attempt to set an owner that does not match the current user when binding a package.
0x00000000000000000000000200000000 SET_PASSTHRU
Attempt to issue the SET PASSTHRU statement.
0x00000000000000000000000400000000 TRANSFER
Attempt to transfer an object.
0x00000000000000000000000800000000 ALTER_WITH_GRANT
Attempt to verify whether ALTER with GRANT privilege is held.
0x00000000000000000000001000000000 DELETE_WITH_GRANT
Attempt to verify whether DELETE with GRANT privilege is held.
0x00000000000000000000002000000000 INDEX_WITH_GRANT
Attempt to verify whether INDEX with GRANT privilege is held
0x00000000000000000000004000000000 INSERT_WITH_GRANT
Attempt to verify whether INSERT with GRANT privilege is held.
0x00000000000000000000008000000000 SELECT_WITH_GRANT
Attempt to verify whether SELECT with GRANT privilege is held.
0x00000000000000000000010000000000 UPDATE_WITH_GRANT
Attempt to verify whether UPDATE with GRANT privilege is held.
0x00000000000000000000020000000000 REFERENCE_WITH_GRANT
Attempt to verify whether REFERENCE with GRANT privilege is held.
0x00000000000000000000040000000000 USAGE
Attempt to use a sequence or an XSR object or to verify whether USAGE privilege is held if Audit Event is CHECKING_TRANSFER.
0x00000000000000000000080000000000 SET ROLE
Attempt to set a role.
0x00000000000000000000100000000000 EXPLICIT_TRUSTED_CONNECTION
Attempt to establish an explicit trusted connection.
0x00000000000000000000200000000000 IMPLICIT_TRUSTED_CONNECTION
Attempt to establish an implicit trusted connection.
0x00000000000000000000400000000000 READ
Attempt to read a global variable.
0x00000000000000000000800000000000 WRITE
Attempt to write a global variable.
0x00000000000000000001000000000000 SWITCH_USER
Attempt to switch a user ID on an explicit trusted connection.
0x00000000000000000002000000000000 AUDIT_USING
Attempt to associate an audit policy with an object.
0x00000000000000000004000000000000 AUDIT_REPLACE
Attempt to replace an audit policy association with an object.
0x00000000000000000008000000000000 AUDIT_REMOVE
Attempt to remove an audit policy association with an object.
0x00000000000000000010000000000000 AUDIT_ARCHIVE
Attempt to archive the audit log.
0x00000000000000000020000000000000 AUDIT_EXTRACT
Attempt to extract the audit log.
0x00000000000000000040000000000000 AUDIT_LIST_LOGS
Attempt to list the audit logs.
0x00000000000000000080000000000000 IGNORE_TRIGGERS
Attempt to ignore the triggers associated with a database object.
0x00000000000000000100000000000000 PREPARE
Attempt to prepare an SQL statement and the user does not hold the necessary object level privilege or DATAACCESS authority.
0x00000000000000000200000000000000 DESCRIBE
Attempt to describe a statement and the user does not hold the necessary object level privilege or DATAACCESS authority.
0x00000000000000000400000000000000 SET_USAGELIST
Attempt to set the usage list state.