Giving users access to the Informix 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 Cloud Pak for Data users one of the following roles on an integrated Informix database:

Role Description
Admin This role can:
  • Access to all of the features in the database console
  • Give other users access to the database
User This role can:
  • Create tables
  • Use their own tables
  • Give other users access to their tables

Procedure

To give a user access to an integrated database:

Procedure

  1. Sign in to the Cloud Pak for Data web client.
  2. From the navigation, select Services> Instances.
  3. Open the actions menu for the database that you want to manage, and select Manage Access.
  4. Click Add users.
  5. Select the user and specify the appropriate role for the user.
  6. Click OK.
    Note:
    You must not use the user name in4mix because this is the name of the instance owner in the private-server installation. You should not use the user name admin, if possible. If you are having a user admin you will need to copy its password into the Informix authentication secrets by using the steps:
    1. Open the project in which you installed your Informix service: Home → Projects → Name of your project.
    2. Open the “Secrets” in the “Inventory” pane of the project page.

    3. Open the informix-<crid>-admin-cpdauth secret.

      The <crid> is the numerical part of the CR Name informix-1234...

    4. Copy the password by clicking on the “Copy to clipboard” icon.
    5. Go back to the secrets page.
    6. Open the informix-<crid>-auth secret.
    7. Select “Edit Secret” action from the “Action” drop-down.
    8. Enter the copied password into the apppassword key.
    9. Save the change.

What to do next

After a user has access to the database, they can work with the database. For more information, see Working with IBM® Informix Enterprise Edition databases.