Provisioning workflow for database-level objects
The Provisioning workflow for database-level objects is used to create, update, delete MS SQL users, and update database-role membership.
The Provisioning workflow for database-level objects is used to create, update, delete MS SQL users, and update database-role membership.
You can create SQL USER WITHOUT LOGIN, SQL USER WITH LOGIN, WINDOWS USER, WINDOWS GROUP, and SQL USER WITH PASSWORD types of users in MS SQL Server.
IMPORTANT:
The SQL user is created and automatically mapped to the login with the same username if it exists, or else a new login is created.
A login is not required to access the SQL server for SQL USER WITH PASSWORD. These users are only applicable to a contained database.
IMPORTANT:
NOTE: For SQL USER WITH LOGIN, the password text field is used only for login creation.
A MS SQL user is created successfully.
The following topic briefs about the procedure to change password, lock user, unlock users, and change role membership.
The password is updated.
The user is locked or unlocked based on the action.
The role membership is updated.
The following procedure describes how to delete an SQL user.
To delete a MS SQL user
The user account is disabled immediately on the MS SQL database based on deferred deletion value of the UNSAccountB table in One Identity Manager.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center