Defining DB2 Records › What is the SAFELIST Record? › Field Descriptions

Field Descriptions

CLASS(class)

Specifies the type of DB2 resource that this SAFELIST entry will apply.

SERVICE(service)

Specifies the access that the user must be attempting in order for the SAFELIST record to apply. The service must be a valid service for the class indicated.

RESOURCE(resource)

Specifies the name of the resource that is for unrestricted access. For system privileges this will be the privilege.

Certain resource classes have two-level qualified resource names. The resource name specified in a safelist entry for any of these classes must either contain a period (the qualifier separator) or it must terminate in a dash. Failure to comply with this restriction will result in a syntax failure with error message ACFD2206. If a dash terminates the resource name, no qualifier separator is necessary.

COLUMN(column name)

Specifies a particular column within the table specified in the resource parameter. This field is optional and can only be used when specifying the service UPDATE or REFER on class DB2TABLE.