DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.SECURITYPOLICYEXEMPTIONS catalog view

Each row represents a security policy exemption that was granted to a database authorization ID.

Table 1. SYSCAT.SECURITYPOLICYEXEMPTIONS Catalog View
Column Name Data Type Nullable Description
GRANTOR VARCHAR (128)   Grantor of the exemption.
GRANTEE VARCHAR (128)   Holder of the exemption.
GRANTEETYPE CHAR (1)  
  • G = Grantee is a group
  • R = Grantee is a role
  • U = Grantee is an individual user
SECPOLICYID INTEGER   Identifier for the security policy for which the exemption was granted. For the name of the security policy, select the SECPOLICYNAME column for the corresponding SECPOLICYID value in the SYSCAT.SECURITYPOLICIES catalog view.
ACCESSRULENAME VARCHAR (128)   Name of the access rule for which the exemption was granted.
ACCESSTYPE CHAR (1)   Type of access to which the rule applies.
  • R = Read access
  • W = Write access
ORDINAL INTEGER   Position of the security label component in the security policy to which the rule applies.
ACTIONALLOWED CHAR (1)   If the rule is DB2LBACWRITEARRAY, then:
  • D = Write down
  • U = Write up
Blank otherwise.
GRANT_TIME TIMESTAMP   Time at which the exemption was granted.