DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.SECURITYLABELACCESS catalog view

Each row represents a security label that was granted to the database authorization ID.

Table 1. SYSCAT.SECURITYLABELACCESS Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of the security label.
GRANTEE VARCHAR (128)   Holder of the security label.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
SECLABELID INTEGER   Identifier for the security label. For the name of the security label, select the SECLABELNAME column for the corresponding SECLABELID value in the SYSCAT.SECURITYLABELS catalog view.
SECPOLICYID INTEGER   Identifier for the security policy that is associated with the security label. For the name of the security policy, select the SECPOLICYNAME column for the corresponding SECPOLICYID value in the SYSCAT.SECURITYPOLICIES catalog view.
ACCESSTYPE CHAR (1)  
  • B = Both read and write access
  • R = Read access
  • W = Write access
GRANT_TIME TIMESTAMP   Time at which the security label was granted.