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:
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:
|
ENFORCED | ENFORCED | CHAR(1) | Indicates the type of access enforced
by the row permission. Column mask is always 'A':
|
IMPLICIT | IMPLICIT | CHAR(1) | Indicates whether the row permission
was implicitly created:
|
ENABLE | ENABLE | CHAR(1) | Indicates whether the row permission
or the column mask is enabled for access control:
|
CREATE_TIME | CREATEDTS | TIMESTAMP | Identifies the timestamp when the row permission or column mask was created. |
LAST_ALTERED | ALTERDTS | 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. |