

Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define DB2 LUW Users
Define DB2 LUW Users
You use the DB2 for LUW User Id Editor to define database users and their respective properties in a DB2 physical model.
To define DB2 users
- Right-click a User Id in the Model Explorer and select Properties.
The DB2 for LUW User Id Editor opens.
- Select a User Id and work with the following options:
Note: Click New
on the toolbar to create a User Id.
- Name
-
Specifies the name of the user id.
- Is User Group
-
Specifies that the selected user id is a user group.
- Click the Role tab and work with the following options:
- Role
-
Specifies the database role of the user ID. Select the check box, or click the Database Role Editor icon (icon) to create a role.
- With Admin Option
-
Specifies whether or not the selected role has administrative privileges. Select the check box.
- Click the Permission tab and grant permissions to users or user groups on the selected user ID.
- Click the Comment tab and enter any comments you want associated with the user ID.
- Click the Where Used tab to view where the user ID is used in the model.
- Click the UDP tab to work with user-defined properties for the user ID.
- Click the Notes tab to view history information and view or edit user notes.
- Click Close.
The DB2 for LUW User Id Editor closes.
More information:
Add a Comment in a Property Editor
Add a UDP in a Physical Property Editor
Copyright © 2013 CA.
All rights reserved.
 
|
|