Chat now with support
Chat mit Support

Identity Manager 9.0 LTS - 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

Creating a MySQL user

Creating a MySQL user

The following procedure describes how to create a MySQL user.

To create a MySQL user

  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. Click Add.
  4. Provide the relevant information for the new user.

    NOTE: The Login name for the user must be unique.

  1. Provide a password in the Password text field. If not provided, the value from the DefaultUserPassword variable is used.

  2. Optionally provide the hostname in the Hostname field.

  3. Click Save.

    The MySQL user is provisioned successfully.

Updating attributes of MySQL user

Updating attributes of MySQL user

The following topic briefs about the process of updating attributes of a MySQL user.

To change the password:
  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In the Custom target system, select the user to be updated.
  4. Provide the new password in the Password text field.
  5. 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 privilege 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 a MySQL user

Deleting a MySQL user

The following procedure describes how to delete a MySQL user.

To delete a MySQL 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 MySQL database based on deferred deletion value of the UNSAccountB table in One Identity Manager.

User scenario

This chapter provides information about user scenarios in the Database Systems Integration (DSI) module.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen