SYSCONTROLS

The SYSCONTROLS view contains one row for each row permission or column mask defined by the CREATE PERMISSION or CREATE MASK statements.

The following table describes the columns in the SYSCONTROLS view:

Table 1. SYSCONTROLS 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.
RCAC_OWNER	CREATOR	VARCHAR(128)	Creator of the row permission or column mask.
TABLE_SCHEMA	TBSCHEMA	VARCHAR(128)	Schema name of the table for which the row permission or column mask is defined.
TABLE_NAME	TBNAME	VARCHAR(128)	Name of the table for which the row permission or column mask is defined.
TBCORRELATION	TBCORRNAME	VARCHAR(128)	The correlation name of the table for which the row permission or column mask is defined. If not specified, a value is generated.
COLUMN_NAME	COLNAME	VARCHAR(128)	Column name for which the column mask is defined. Contains a blank for a row permission.
SYSTEM_COLUMN_NAME	SYS_CNAME	CHAR(10)	The system name of the column. Contains a blank for a row permission
SYSTEM_TABLE_NAME	SYS_TNAME	CHAR(10)	The system name of the table.
SYSTEM_TABLE_SCHEMA	SYS_DNAME	CHAR(10)	The system name of the schema.
CONTROL_TYPE	CONTROLTYP	CHAR(1)	Indicates the type of access control: R Row permission M Column mask
ENFORCED	ENFORCED	CHAR(1)	Indicates the type of access enforced by the row permission. Column mask is always 'A': A All access
IMPLICIT	IMPLICIT	CHAR(1)	Indicates whether the row permission was implicitly created: N The row permission was not implicitly created or this is a column mask. Y Row permission was implicitly created.
ENABLE	ENABLE	CHAR(1)	Indicates whether the row permission or the column mask is enabled for access control: N Not enabled Y Enabled
CREATE_TIME	CREATEDTS	TIMESTAMP	Identifies the timestamp when the row permission or column mask was created.
LAST_ALTERED	ALTEREDTS	TIMESTAMP Nullable	Identifies the timestamp when the row permission or column mask was last changed. Contains the null value if it has never been altered.
IASP_NUMBER	IASPNUMBER	SMALLINT	Specifies the independent auxiliary storage pool (IASP) number.
LABEL	LABEL	VARGRAPHIC(50) CCSID 1200 Nullable	A character string provided by the LABEL statement. Contains the null value if a label does not exist.
LONG_COMMENT	REMARKS	VARGRAPHIC(2000) CCSID 1200 Nullable	A character string supplied with the COMMENT statement. Contains the null value if there is no long comment.
RULETEXT	RULETEXT	DBCLOB(2M) CCSID 1200	The source text of the search condition or expression portion of the CREATE PERMISSION or CREATE MASK statement.