Each row represents a row permission or column mask.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
CONTROLSCHEMA | VARCHAR (128) | Schema of the row permission or column mask. | |
CONTROLNAME | VARCHAR (128) | Name of the row permission or column mask. | |
OWNER | VARCHAR (128) | Owner of the row permission or column mask. | |
OWNERTYPE | CHAR (1) |
|
|
TABSCHEMA | VARCHAR (128) | Schema of the table on which the row permission or column mask is defined. | |
TABNAME | VARCHAR (128) | Name of the table on which the row permission or column mask is defined. | |
COLNAME | VARCHAR (128) | Column name on which the column mask is defined. Blank if this is a row permission. | |
CONTROLID | INTEGER | Identifier of the control. | |
CONTROLTYPE | CHAR (1) |
|
|
ENFORCED | CHAR (1) |
|
|
IMPLICIT | CHAR (1) |
|
|
ENABLE | CHAR (1) |
|
|
VALID | CHAR (1) |
|
|
RULETEXT | CLOB (2M) | The source text of the search condition or case expression portion of the CREATE PERMISSION or CREATE MASK statement. | |
TABCORRELATION | VARCHAR (128) | The correlation name of the table on which the row permission or column mask is defined. Blank if not specified. | |
QUALIFIER | VARCHAR (128) | Value of the default schema at the time of object definition. Used to complete any unqualified references. | |
FUNC_PATH | CLOB (2K) | SQL path in effect when the control was defined. | |
COLLATIONSCHEMA | VARCHAR (128) | Schema name of the collation for the control. | |
COLLATIONNAME | VARCHAR (128) | Unqualified name of the collation for the control. | |
COLLATIONSCHEMA_ORDERBY | VARCHAR (128) | Schema name of the collation for the ORDER BY clauses in the control. | |
COLLATIONNAME_ORDERBY | VARCHAR (128) | Unqualified name of the collation for the ORDER BY clauses in the control. | |
CREATE_TIME | TIMESTAMP | Time at which the row permission or column mask was created. | |
ALTER_TIME | TIMESTAMP | Time at which the row permission or column mask was last altered. | |
ENVSTRINGUNITS | VARCHAR (11) | Default string units when the object was created. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |