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.
- Create an operating system user. For example, pimview
Add the operating system user pimview to
the group, DB2USERS.
- 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.
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