SYSCAT.CONTROLS catalog view

Each row represents a row permission or column mask.

Table 1. SYSCAT.CONTROLS Catalog View
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)  
  • S = System
  • U = User
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)  
  • C = Column mask
  • R = Row permission
ENFORCED CHAR (1)  
  • A = All access
IMPLICIT CHAR (1)  
  • N = The row permission was explicitly created or this is a column mask
  • Y = The row permission was implicitly created
ENABLE CHAR (1)  
  • N = Not enabled
  • Y = Enabled
VALID CHAR (1)  
  • N = The control is invalid
  • Y = The control is valid
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.