Row Permissions (DB2)

Auxiliary tables are supported for IBM DB2 for z/OS 10 and higher. PowerDesigner models row permissions as extended objects with a stereotype of <<Row permission>>.

Creating a Mask

You can create a row permission in any of the following ways:

Select Model > Row Permissions to access the List of Row Permissions, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Row Permission.

Row Permission Properties

You can modify an object's properties from its property sheet. To open a row permission property sheet, double-click its Browser entry in the Row Permissions folder.

The following extended attributes are available on the General tab:

Name	Description
Table	Specifies the table on which the row permission is created. Scripting name: Table
Enabled	Specifies that the row permission is to be enabled or disabled for row access control. Scripting name: RowPermissionEnabled

Name

Description

Table

Specifies the table on which the row permission is created.

Scripting name: Table

Enabled

Specifies that the row permission is to be enabled or disabled for row access control.

Scripting name: RowPermissionEnabled

The following extended attributes are available on the Search condition tab:

Name	Description
Correlation name	Specifies a correlation name that can be used within search-condition to designate the table. Scripting name: TableCorrelation
Search condition	Specifies a condition that can be true, false, or unknown for a row of the table. Search condition follows the same rules used by the search condition in a WHERE clause of a subselect. Scripting name: SearchCondition

Name

Description

Correlation name

Specifies a correlation name that can be used within search-condition to designate the table.

Scripting name: TableCorrelation

Search condition

Specifies a condition that can be true, false, or unknown for a row of the table. Search condition follows the same rules used by the search condition in a WHERE clause of a subselect.

Scripting name: SearchCondition