Chat now with support
Chat with Support

Identity Manager 8.2.1 - Administration Guide for Connecting to Native Databases through Database Systems Integration Module

Database Systems Integration Module Installing DSI Working with Oracle Database Working with MSSQL Working with SAP HANA Working with the MySQL database template User scenario Troubleshooting

Updating attributes of an Oracle user

The following procedures describes how to create the Oracle users on Oracle database.

To change the password:
  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts. To view the target system name, expand the required target system root.
  3. Provide the new password in the Password text field.
  4. Click Save.

    The password is updated.

To lock or unlock users:
  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target systems, select the user to be updated.
  4. Select the User account is disabled check box to lock or unlock the user.

    The user is locked or unlocked based on the action.

To change role membership:
  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target system, select the user to be updated.
  4. From the Assign Groups section, add or remove groups to update the role membership.

    The role membership is updated.

Deleting an Oracle user

The following procedure describes how to delete an Oracle user.

To delete an Oracle user

  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target systems, select the user and click Delete.

The user account is disabled immediately on the Oracle database based on deferred deletion value of the UNSAccountB table in One Identity Manager.

Updating role membership

The following describes how to create Oracle users on the Oracle database.

To update role membership
  1. Open the Manager.

  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target systems, select the Group to be updated.
  4. From the Assign Groups section, add or remove groups to update the role membership.

    The role membership is updated.

Working with MSSQL

This chapter provides information about the Microsoft SQL (MS SQL) database templates for server level and database level provided in the Database Systems Integration (DSI) module that is used to create mappings, workflows, startup configurations, and synchronize objects.

The server-level template is used to connect to the master database to manage server objects. The database-level template is used to connect to specific databases to manage database objects.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating