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>>.
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 .
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 |
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 |