Each row represents a security policy exemption that was granted to a database authorization ID.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
GRANTOR | VARCHAR (128) | Grantor of the exemption. | |
GRANTEE | VARCHAR (128) | Holder of the exemption. | |
GRANTEETYPE | CHAR (1) |
|
|
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.
|
|
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:
|
|
GRANT_TIME | TIMESTAMP | Time at which the exemption was granted. |