SYSCONTROLSDEP

The SYSCONTROLSDEP view records the dependencies of row permissions and column masks.

The following table describes the columns in the SYSCONTROLSDEP view:

Table 1. SYSCONTROLSDEP view
Column Name	System Column Name	Data Type	Description
RCAC_SCHEMA	SCHEMA	VARCHAR(128)	Schema name of the row permission or column mask.
RCAC_NAME	NAME	VARCHAR(128)	Name of the row permission or column mask.
CONTROL_TYPE	CONTROLTYP	CHAR(1)	Indicates the type of access control: R Row permission M Column mask
OBJECT_SCHEMA	BSCHEMA	VARCHAR(128)	Name of the schema that contains the object.
OBJECT_NAME	BNAME	VARCHAR(128)	Name of the object the row permission or column mask is dependent on.
OBJECT_TYPE	BTYPE	CHAR(24)	Indicates the object type of the object referenced in the row permission or column mask. COLUMN The object is a column in a table. FUNCTION The object is a function. MATERIALIZED QUERY TABLE The object is a materialized query table. SEQUENCE The object is a sequence. TABLE The object is a table. TYPE The object is a distinct type. VARIABLE The object is a variable. VIEW The object is a view.
COLUMN_NAME	BCOLNAME	VARCHAR(128)	Column name for the object when OBJECT_TYPE has a value of 'COLUMN'. In this case, OBJECT_NAME contains the table name for the column. Contains a blank if object is not a column.
SYSTEM_TABLE_NAME	SYS_TNAME	CHAR(10)	The system name of the table upon which the row permission or column mask is defined.
SYSTEM_TABLE_SCHEMA	SYS_DNAME	CHAR(10)	The system name of the schema of the table upon which the row permission or column mask is defined.
IASP_NUMBER	IASPNUMBER	SMALLINT	Specifies the independent auxiliary storage pool (IASP) number.
PARM_SIGNATURE	SIGNATURE	VARCHAR(10000) Nullable	This column identifies the routine signature. Contains the null value if the object is not a routine.