Previous Topic: Define a DB2 LUW Security PolicyNext Topic: Define a DB2 LUW Alias


Define a DB2 LUW Trusted Context

Use the Trusted Context editor to create and set properties for a trusted context in a DB2 LUW physical model. You use the tabs in the editor to identify trusted context attributes and users.

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

To define a DB2 LUW trusted context

  1. Right-click a Trusted Context in the Model Explorer and select Properties.

    The DB2 LUW Trusted Context Editor opens.

  2. Select a trusted context 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 trusted context. 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 trusted context.

    Enabled

    Specifies whether or not the trusted context is created in the enabled or disabled state.

    Authorization Id

    Specifies the user ID to associate with the trusted context. Select a User ID from the drop-down list or click the New New icon in property editors to create a new object icon to create one.

    Default Role

    Specifies the role name to use when a trusted connection is using the selected trusted context. Select a role from the drop-down list or click the New New icon in property editors to create a new object icon to create one.

    Audit Policy

    Specifies the audit policy to associate with the trusted context. Select an audit policy from the drop-down list or click the New New icon in property editors to create a new object icon to create one.

    Generate

    Specifies whether or not to generate DDL for this object during Forward Engineering.

  3. Click the Trusted Context Attribute tab and work with the following options:
    Name

    Specifies the name of the trusted context attribute that you want to be part of the trusted context.

    Attribute Type

    Specifies the value for the trusted context attribute. The value can be address or encryption.

    Value

    Specifies the address for the selected trusted context attribute. This field is available only when you select Address for Attribute Type.

    Encryption Type

    Specifies the type of encryption for the selected trusted context attribute. The Encryption Type can be none, low, or high.

  4. Click the Trusted Context User tab and work with the following options:
    Name

    Specifies the name of the user who uses the trusted connection, which is based on the selected trusted context.

    User Type

    Specifies the type of the user who connects to the trusted context.

    Authorization ID

    Specifies the authorization ID of the selected user. Select from the drop-down list. This field is displayed only if you have selected the User Type as Authorization Name.

    Database Role

    Specifies the database role of the selected user. Select from the drop-down list. This field is displayed only if you have selected the User Type as Authorization Name.

    Is Authenticated

    Specifies whether or not the connection is established using authentication.

  5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  6. (Optional) Click the UDP tab to work with user-defined properties for the object.
  7. (Optional) Click the Notes tab to view and edit user notes.
  8. Click Close.

    The trusted context is saved and the DB2 for LUW Trusted Context Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor