IBM Security Privileged Identity Manager, Version 2.1.0

Creating a user to access database views

Create a database user to access the views that are required for the IBM® Security Guardium® integration

About this task

This database user is a read-only user and is only required for the Guardium integration.

Procedure

Create a database user.
1. Create an operating system user. For example, pimview
  Add the operating system user pimview to the group, DB2USERS.
2. Change the password for user pimview.
  Note:
  - For Windows users, this step is not applicable if you set your password to Never Expire in the previous step.
  - This step is compulsory for Unix and Linux users.

Grant the user permissions to access the views.

Note: Use the user that you created in Installing and configuring the database server or a database administrator account to grant the permissions.

db2 connect to idmdb user piminstu using <password>
GRANT SELECT ON V_PIM_CICO_HISTORY_DB_RSRC TO <username>
GRANT SELECT ON V_PIM_CRED_INFO_DB_RSRC TO <username>
GRANT SELECT ON V_PIM_CRED_DETAILS_DB_RSRC TO <username>
db2 disconnect current

Feedback