DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.SECURITYPOLICYCOMPONENTRULES catalog view

Each row represents the read and write access rules for a security label component of the security policy.

Table 1. SYSCAT.SECURITYPOLICYCOMPONENTRULES Catalog View
Column Name Data Type Nullable Description
SECPOLICYID INTEGER   Identifier for the security policy.
COMPID INTEGER   Identifier for the security label component of the security policy.
ORDINAL INTEGER   Position of the security label component as it appears in the security policy, starting with 1.
READACCESSRULENAME VARCHAR (128)   Name of the read access rule that is associated with the security label component.
READACCESSRULETEXT VARCHAR (512)   Text of the read access rule that is associated with the security label component.
WRITEACCESSRULENAME VARCHAR (128)   Name of the write access rule that is associated with the security label component.
WRITEACCESSRULETEXT VARCHAR (512)   Text of the write access rule that is associated with the security label component.