Physical Modeling › DB2 z/OS Property Editors › Define a DB2 z/OS Database Role

Previous Topic: DB2 z/OS Property Editors

Next Topic: Define a DB2 z/OS Database

Define a DB2 z/OS Database Role

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

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 New icon in property editors to create a new object 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.

    Generate

    Generates DDL for this object during Forward Engineering.

  3. (Optional) Click the Comment tab and enter any comments you want associated with the database role.
  4. (Optional) Click the UDP tab to work with user-defined properties for the database role.
  5. (Optional) Click the Notes tab to view history information and view or edit user notes.
  6. 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