IFCID141: Audit DDL Grant/Revoke

The IFCID141 DD contains the extracted IFCID 141 (Audit DDL Grant/Revoke) records.

Fields

Begin program-specific programming interface information.

The IFCID141 DD has the following fields:

GRANTOR/REVOKER

The authorization ID of the user who gave or revoked the access.

Field Name: QW0141AC and QW0141OR

REASON

The reason why access was granted or revoked.

Field Name: QW0141RE

RETURN

The SQL return code.

Field Name: QW0141CO

AUTHID TYPE

The authorization ID type. AUTHID TYPE can have the following values:

PRIMARY OR SECONDARY AUTH ID
ROLE

Field Name: QW0141OT

OBJECT

The object type. OBJECT can have the following values:

ACEE
APPLICATION PLAN
BUFFERPOOL
COLLECTION
DATABASE
DISTINCT TYPE
FUNCTION
SESSION VARIABLE
JAR
PACKAGE
PROCEDURE
SCHEMA
SEQUENCE
STORAGE GROUP
ROLE
ROW
TABLE OR VIEW
TABLESPACE
TRUSTED CONTEXT
USER AUTH
N/A

Field Name: QW0141OB

OPTIONS

The options that were used in the host to check the SQL statement. The bits of this field are used as indicators. If all bits are 0, the statement is not an SQL statement. See the OPTIONS field of IFCID140: Audit Authorization Failures for a full description of the bits of this field.

Field Name: QW0141HO

SQL STMT

The SQL statement text. Long SQL text can be truncated.

Field Name: QW0141TX

Example

GRANTOR : SYSADM           REASON : N/A                                 RETURN:  0000000562
AUTHID TYPE: PRIMARY OR SECONDARY AUTH ID                                                  
OBJECT  : APPLICATION PLAN OPTIONS: X'0400000000000000'                                    
SQL STMT: GRANT BIND, EXECUTE ON PLAN DSNTEP2 TO PUBLIC

End program-specific programming interface information.