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

1. Right-click a User Id in the Model Explorer and select Properties.

   The DB2 for LUW User Id Editor opens.

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

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

4. Click the Permission tab and grant permissions to users or user groups on the selected user ID.
5. Click the Comment tab and enter any comments you want associated with the user ID.
6. Click the Where Used tab to view where the user ID is used in the model.
7. Click the UDP tab to work with user-defined properties for the user ID.
8. Click the Notes tab to view history information and view or edit user notes.
9. 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