Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define a DB2 LUW Database Role

Define a DB2 LUW Database Role

Use the Database Role editor to create a role name that you can use to group one or more privileges and assign to a user or to another role.

Note: This topic applies to DB2 for LUW versions 9.5 and 9.7 only.

To define a DB2 database role

1. Right-click a Database Role in the Model Explorer and select Properties.

   The DB2 Database Role Editor opens.

2. Select a database role name and work with the following options:

   Note: Click New on the toolbar to create a database role. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the name of the database role.

   (DB2 LUW only) Audit Policy

   Specifies the Audit Policy to associate with the Database Role.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Click the Comment tab and enter any comments you want associated with the database role.
4. Click the UDP tab to work with user-defined properties for the database role.
5. Click Close.

   The Database Roles Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Edit User Notes or View Object History