Assign a connection profile privilege

Manage connection profile privilege for product users.

About this task

A database administrator and console administrator can manage a connection profile privilege from the Settings > Users and privileges page. The user IDs are specific to the product and are independent of operating system user IDs. User roles can be assigned either by an administrator or by a user with database owner access privilege. You can also grant user or owner privilege to a group.

Procedure

  1. Log in to IBM® Db2® Data Management Console.
  2. Click Administration and select Users and privileges.
    The connection profile list with profile use, profile owner, profile user group, and profile owner group information displays.
  3. Assign users for a specific connection profile.
    1. Select the connection profile and click Assign User.
    2. In the Assign page, add new users or select the users or groups to assign the profile user privilege.
    3. Click OK .
  4. Assign owners for a specific connection profile.
    1. Select the connection profile and click Assign Owner.
    2. In the Assign page, add new users or select the users or groups to assign the profile owner privilege.
    3. Click OK .
  5. Revoke privilege for a specific connection profile.
    1. Select the connection profile and click Revoke.
    2. In the Assign page, select the users or groups to revoke the profile privilege.
    3. Click OK .
    Note: When a user and the group which the user belongs to has different privileges, the higher privilege will be assigned to the user.