Mapping sets and object types for the database-level template

The Microsoft SQL database-level template has the following mapping sets:

• Users: Maps all users to access the databases such as, SQL_USER_WITHOUT_LOGIN, SQL_USER_WITH_LOGIN, SQL_USER_WITH_PASSWORD (applicable only for contained databases), WINDOWS_USER and WINDOWS_GROUP into One Identity Manager.
• Roles: Maps all database and application roles for the database into One Identity Manager.
• UserHasRoles: Maps all users and their role membership into One Identity Manager.
• RoleInRole: Maps all roles and their role membership into One Identity Manager.
• UsersExtended: Maps all user properties for provisioning from One Identity Manager to MS SQL.

  NOTE: Before updating the default mapping sets, you should save the backup of the One Identity Manager database.

Mapping object types between SQL tables and One Identity Manager tables

The following table here describes mapping database object types in Microsoft SQL Server to the corresponding UNS tables of One Identity Manager.

Table 3: Mapping table for MS SQL database-level object types

MS SQL database-level object types
Mapping set name	MS SQL objects	One Identity Manager table
Users	sys.database_principals	UNSAccountB
Roles	sys.database_principals	UNSGroupB
UserHasRoles	sys.database_role_members	UNSAccountBInUNSGroupB
RoleInRole	sys.database_role_members	UNSGroupBInUNSGroupB
UsersExtended	sys.sysusers	UNSAccountB