Create a user that you can use to create and access the

Identity Resolution

tables and database objects. The user must not be a database owner (dbo). A database owner is a member of the

sysadmin

fixed server role. If a member of the

sysadmin

fixed server role creates an object, the object belongs to dbo, not to the member. In this case,

Identity Resolution

cannot identify the database objects that the user creates. You must add the user to the

db_ddladmin

fixed database role to create triggers on the USTs.

The following table describes the fixed database roles to which you must add the user that you create:

Database Type	Fixed Database Role
Source database without synchronization	db_datareader
Target database without synchronization	db_datareader db_datawriter db_ddladmin
Source database with synchronization	db_datareader db_datawriter db_ddladmin
Target database with synchronization	db_datareader db_datawriter db_ddladmin