IFCID 271 - Row Level and Column Level Access Control

This topic shows detailed information about Record Trace - IFCID 271 - Row Level and Column Level Access Control.

This IFCID records the following events:

When a row permission or column mask is created.
When a row permission or column mask is dropped.
When a row permission or column mask is altered.

Record trace - IFCID 271 - Row Level and Column Level Access Control

The field labels shown in the following sample layout of Record Trace - IFCID 271 - Row Level and Column Level Access Control are described in the following section.


-------------------------------------------------------------------------------------------------------------------------
STATEMENT TYPE: CREATE      OBJECT .......: ROW PERMISSION    SQLCODE ......:         -1    STMT LENGTH ..:         78
SQL STATEMENT : THIS IS A SQL STATEMENT TEXT TO VERIFY ITS CORRECT PRESENTATION IN BATCH AUDIT
-------------------------------------------------------------------------------------------------------------------------

TYPE

Identifies the SQL statement type:

CREATE or C: Creates row permission or column mask.
DROP or D: Drops row permission or column mask.
ALTER or A: Alters row permission or column mask.

Otherwise, a hexadecimal value is shown.

Field Name: QW0271TY

OBJECT

Identifies the object type:

Row permission (R)
Column mask (M)

Otherwise, a hexadecimal value is shown.

Field Name: QW0271OB

SQLCODE

The SQL code from the execution of the CREATE, DROP, or ALTER statement.

Field Name: QW0271SQ

STMT LENGTH

The length of the SQL statement.

Field Name: QW0271SL

SQL STATEMENT

The SQL statement text associated with the table access. The maximum length is 4000 bytes. Long SQL text can be truncated.

Field Name: QW0271SS