Chat now with support
Chat with Support

Identity Manager 9.2 - 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 Microsoft SQL login

Creating a Microsoft SQL login

You can create SQL LOGIN, WINDOWS LOGIN, and WINDOWS GROUP types of logins in the MS SQL Server.

  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 login.

    NOTE:

    • For WINDOWS LOGIN and WINDOWS GROUP, the user name must be in <domain\username> format.
    • The Login name for the user must be unique.

  5. Provide a password in the Password text field. If not provided, the value from the DefaultUserPassword variable is used.
  6. Select one of the following options, SQL LOGIN, WINDOWS LOGIN, or WINDOWS GROUP from the AccountType drop-down list to proceed further with the process.
  7. Click Save.

    The user is provisioned in MS SQL successfully.

Updating attributes of a Microsoft SQL login

Updating attributes of a Microsoft SQL login

The following procedures provides information about the process to change password, lock users, unlock users, and change membership.

To change the password (applicable only to SQL LOGIN):
  1. Open the Manager.
  2. Navigate to Custom target systems | <required target system root> | User accounts.
  3. In Custom target system, select the login 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 login 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 login 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 Microsoft SQL login

Deleting a Microsoft SQL login

The following procedure describes how to delete an SQL login.

To delete a MS SQL login

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

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

Updating server-role membership

Updating server-role membership

The following topic briefs about the procedure to update the server-role membership.

To update server-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 Group to be updated.
  4. From the Assign Groups section, add or remove groups to update the server-role membership.

    The server-role membership is updated.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating