Previous Topic: CADB2SUA—Security Validation TraceNext Topic: CADB2SGS—DB2 SQL Generated Statement Report


Field Descriptions
User ID Grantee

Specifies the logonid that was used in the resource validation call for this resource.

Resource Type

Indicates the type of resource for which the resource validation call was made. This resource type is the same one specified on the INCLUDE statement.

Resource Name

Specifies the resource name for which the resource validation call was made. This resource name is the same name included through the resource extract process detailed in the CADB2SY2 component.

Access Allowed

Specifies the privileges that are permitted to the resource. If the user named in the USERID GRANTEE column is the user that created the resource, this field value is: <NOT CHECKED>.

Owner Option

Indicates that the logonid owns the resource, so further resource validation calls are bypassed. A logonid can own a resource through an unscoped SECURITY privilege, or by matching the $LIDOWNER or $UIDOWNER in the resource rule. Owners of a resource are given the WITH GRANT OPTION privilege when the SQL GRANT statements are created. The value in this field is OWNER if the logonid in the USERID GRANTEE field has an unscoped SECURITY privilege or matches the $LIDOWNER or $UIDOWNER in the resource rule. The value in this field is DB2 OWNER if the user named in the USERID GRANTEE column is the user that created the resource.