Chat now with support
Chat with Support

Identity Manager 8.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 role membership

Updating role membership

The following describes the process of updating the role membership of a SAP HANA user.

  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target system, 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 the MySQL database template

This chapter provides information about the MySQL database template provided in the Database Systems Integration module that is used to create mappings, workflows, startup configurations, and synchronize objects.

Features supported

Features supported

The following features are supported in the MySQL database.

  • Read all user accounts and their attributes

  • Read all user privileges
  • Read user assigned privileges

The following features are supported in the MySQL database user

  • Create, read, update, and delete users
  • Change password
  • Lock or unlock user
  • Change privilege membership

Prerequisites to configure the MySQL database

Prerequisites to configure the MySQL database

Ensure that the following prerequisites are met before configuring the MySQL database.

  • Before creating a new synchronization project on the MySQL database, install MySQL client on a system that is set as the Job server and the client system.
  • Download and install the MySQL .NET connector version 6.9.12. Ensure that the MySQL.data.dll is available on the Job server and in the location where the One Identity Manager is installed.
    • Ensure that the information about the following attributes of the MySQL target system are available.

      • Hostname

      • Username
      • Password
      • Database- by default, mysql is the fixed entry.
    • The native database configuration server function must be enabled on the Designer for the Job server.
    • The Information on assigned privileges for MySQL cannot be retrieved directly using the existing schema. You must create custom views in the MySQL server using the sql script file MYSQL_SERVER_VIEWS.sql available in DSI/ConfigFiles location. To create custom views run the following queries in the mysql server before creating synchronization project for MySQL:
      • CREATE VIEW mysql.all_privileges AS SELECT DISTINCT privilege_type from information_schema.USER_PRIVILEGES query.
      • CREATE VIEW mysql.user_privileges AS SELECT * from information_schema.USER_PRIVILEGES query.

    For more information on assigning server function, refer the One Identity Manager Configuration Guide.

  • Related Documents