SYSCAT.SECURITYPOLICIES catalog view

Each row represents a security policy.

Table 1. SYSCAT.SECURITYPOLICIES Catalog View
Column Name Data Type Nullable Description
SECPOLICYNAME VARCHAR (128)   Name of the security policy.
SECPOLICYID INTEGER   Identifier for the security policy.
NUMSECLABELCOMP INTEGER   Number of security label components in the security policy.
RWSECLABELREL CHAR (1)   Relationship between the security labels for read and write access granted to the same authorization ID.
  • S = The security label for write access granted to a user is a subset of the security label for read access granted to that same user
NOTAUTHWRITESECLABEL CHAR (1)   Action to take when a user is not authorized to write the security label that is specified in the INSERT or UPDATE statement.
  • O = Override
  • R = Restrict
CREATE_TIME TIMESTAMP   Time at which the security policy was created.
GROUPAUTHS CHAR (1)   Indicates if authorizations of security labels and exemptions granted to an authorization ID that represents a group will be used or ignored.
  • I = Ignored
  • U = Used
ROLEAUTHS CHAR (1)   Indicates if authorizations of security labels and exemptions granted to an authorization ID that represents a role will be used or ignored.
  • I = Ignored
  • U = Used
REMARKS VARCHAR (254) Y User-provided comments, or the null value.