Giving users access to the Db2 database

By default, only the user who creates the database has access to the database. This user is an Administrator and must give other users access to the database.

About this task

You can give existing IBM Software Hub users one of the following roles on an integrated Db2 database:

Admin
Users with the Admin role can perform the following tasks:
  • Access all of the features in the database console
  • Give other users access to the database
User
Users with the User role can perform the following tasks:
  • Create tables
  • Use their own tables
  • Give other users access to their tables
Tip: You can use user groups in IBM Software Hub to manage and maintain user access and to minimize disruption. You can give user groups access to the database. Then, you can add more users to the user groups in IBM Software Hub without adding users to the database directly.

Procedure

To give a user access to an integrated database, run the following steps according to your environment:
Giving users access to a database that is not part of an HADR configuration:
  1. Sign in to the IBM Software Hub web client.
  2. From the navigation menu, select the Databases tab.
  3. Open the actions menu for the database that you want to manage, and select Access management.
  4. Click Manage users.
  5. Select the user and specify the appropriate role for the user.
  6. Click OK.
Giving users access to an HADR database that has reads on standby enabled:
User access is managed separately for each Db2 database with HADR configured. To ensure that users have access to data regardless of which database is designated as the HADR primary, users must be given access to each database instance.
  1. Sign in to the IBM Software Hub web client.
  2. Ensure that reads on standby is enabled. To learn more, see Enabling reads on standby for Db2.
  3. From the navigation menu, select the Databases tab.
  4. Open the actions menu for the database that you want to manage, and select Access management.
  5. Click Manage users.
  6. Select the user and specify the appropriate role for the user.
  7. Click OK.
Giving users access to an HADR database that does not have reads on standby enabled:

User access is managed separately for each Db2 database with HADR configured. To ensure that users have access to data regardless of which database is designated as the HADR primary, users must be given access to each database instance.

  1. Open the User groups tab and click Manage access to add users for the current primary database.
  2. Run manage_hadr -takeover on the current standby database. See Manually initiating an HADR takeover in Db2 for more information.
  3. Add the same User groups or users by clicking Manage access on the new primary database.
  4. Run manage_hadr -takeover on the former primary database to return it to the original state.
  5. Repeat these steps for all standby databases in the HADR configuration.

What to do next

After a user has access to the database, they can work with the database. For more information, see Getting started with Db2.