IFCID361: Audit Administrative Authorities

The IFCID361 DD contains the extracted IFCID 361 (Audit Administrative Authorities) records.

Fields

Begin program-specific programming interface information.The IFCID361 DD has the following fields:
AUTHORITY TYPE
The type of administrative authority.
ROLE or AUTHID
The label that indicates the type of authorization followed by the role or authid that has the authority
Field Name: QW0361IT and QW0361ID_Var
PRIVILEGE CHECKED
The privilege that is checked. PRIVILEGE CHECKED can have the following values:
  • ALL ON PACKAGES
  • ALLPKAUT
  • ALTER
  • ALTER BUFFERPOOL
  • ALTER INDEX
  • ALTERIN
  • ARCHIVE
  • BIND ADD
  • BIND, REBIND OR FREE
  • BINDAGENT
  • CHECK DATA UTILITY
  • CHECK UTILITY
  • COMMENT ON
  • COMMENT ON INDEX
  • COPY
  • COPY PACKAGE
  • CREATE ALIAS
  • CREATE GLOBAL TEMPORARY TABLE (CREATETMTAB)
  • CREATE IN
  • CREATE INDEX
  • CREATE SECURE OBJECT
  • CREATE STOGROUP
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TABLESPACE
  • CREATE VIEW
  • CREATEDBA
  • CREATEDBC
  • CREATEIN
  • DBADM
  • DBCTRL
  • DBMAINT
  • DDF COMMAND - START, STOP, OR CANCEL
  • DEBUG SESSION
  • DELETE
  • DESCRIBE TABLE
  • DIAGNOSE UTILITY
  • DISPLAY
  • DISPLAY ARCHIVE
  • DISPLAY BUFFERPOOL
  • DISPLAY DATABASE
  • DISPLAY PROFILE
  • DISPLAY RLIMIT
  • DISPLAY THREAD OR DISPLAY DB
  • DISPLAY UTILITY
  • DROP
  • DROP ALIAS
  • DROP INDEX
  • DROP SYNONYM
  • DROPIN
  • EXECUTE
  • EXPLAIN
  • EXPLAIN MONITOR
  • EXPLICIT QUALIFIER USE
  • INSERT
  • LOAD
  • LOCK TABLE
  • MERGECOPY UTILITY
  • MLS READWRITE
  • MODIFY UTILITY
  • MONITOR1
  • MONITOR2
  • OTHER
  • PACKADM
  • QUERY TUNING
  • QUIESCE UTILITY
  • READ
  • RECOVER (UTILITY)
  • RECOVER BSDS
  • RECOVER INDOUBT
  • REFERENCES
  • RENAME INDEX
  • RENAME TABLE
  • REORG
  • REPAIR
  • REPAIR DBD UTILITY
  • REPORT UTILITY
  • RUNSTATS UTILITY
  • SECADM
  • SELECT
  • SET ARCHIVE
  • SQLADM
  • START
  • START DATABASE
  • START DB2, STOP DB2, START DB(*) OR STOP DB(*)
  • START PROFILE
  • START RLIMIT
  • STOP
  • STOP DATABASE
  • STOP OR START TRACE
  • STOP PROFILE
  • STOP RLIMIT
  • STOSPACE UTILITY
  • SUBPKAUT
  • SYSADM
  • SYSCTRL
  • SYSOPR
  • SYSOPR SYSCTRL SYSADM SECADM
  • TERM UTILITY
  • TERMINATE UTILITY ON DATABASE
  • TRIGGER
  • UPDATE
  • USAGE
  • USE
  • VALIDATE SECLABEL
  • WRITE
Field Name: QW0361PR
SOURCE QUALIFIER
The source qualifier.
Field Name: QW0361SC_Var
SOURCE OBJECT
The source object name or original subsystem parameter value.
Field Name: QW0361SN_Var
TARGET QUALIFIER
The target qualifier.
Field Name: QW0361TC_Var
TARGET OBJECT
The target object name or modified z-parm value.
Field Name: QW0361TN_Var
OBJECT TYPE
The object type. OBJECT TYPE can have the following values:
  • ACEE
  • APPLICATION PLAN
  • BUFFERPOOL
  • COLLECTION
  • DATABASE
  • DISTINCT TYPE
  • FUNCTION
  • SESSION VARIABLE
  • JAR
  • PACKAGE
  • PROCEDURE
  • ROLE
  • ROW
  • SCHEMA
  • SEQUENCE
  • STORAGE GROUP
  • TABLE OR VIEW
  • TABLESPACE
  • TRUSTED CONTEXT
  • USER AUTH (System privileges, such as SYSADM or SYSOPR)
  • N/A
Field Name: QW0361OT
OTHER OBJECT
The other object name or subsystem parameter value.
Field Name: QW0361ON_Var
SQL LENGTH
The length of the SQL statement.
Field Name: QW0361LL
SQL STATEMENT
The SQL statement (truncated at 4000 max) .
Field Name: QW0361SQ

Example

AUTHORITY TYPE   : U                    
AUTHID           : USER000             
PRIVILEGE CHECKED: STOP OR START TRACE 
OBJECT TYPE      : USER AUTH           
SQL LENGTH       : 0000000022          
SQL STATEMENT    : -STOP TRACE(AUDIT)
End program-specific programming interface information.