Access Definition

Masks and permissions for DB2 columns and tables are documented with objects of type Access Definition.

This document covers the following topics:

For general information on how to manage objects (for example, how to add or copy an object), see the Object Description documentation.

Add an Access Definition

Virtual machine attributes

Note:
Parameters not listed here are described under Global Attributes.

Parameters
Type
The type of the access definition. Valid values:
M

Mask.

A column mask in DB2 is used for column access control and specifies the value that should be returned for a specified column. Exactly one mask per column is allowed.

In DB2 an enabled column mask does not take effect until the ALTER TABLE statement with the ACTIVATE COLUMN ACCESS CONTROL clause is used to activate column access control for the table.

R

Permission.

Multiple row permissions can be created for a table.

In DB2 an enabled row permission does not take effect until the ALTER TABLE statement with the ACTIVATE ROW ACCESS CONTROL clause is used to activate row access control for the table.

DB2 Name The name of the DB2 table or column.
Correlation Name The correlation name defined in the subselect clause of a view.