Product: Cross-Product
Description: Error: An exception occurred in the Duplicate Search: Error 5.2: The SELECT permission was denied on the object
Environment: All
Version: All 

Answer:

***The following items need to be done by the SQL Server Administrator.***

***It is independent of the RE logins/users.***

Please check all of the following, and add anything that is missing. DO NOT turn off/revoke anything that is already granted! 

1. Databases\RE7\Security\Users 

If REUSER exists, edit its permissions (in the properties); if it does not exist, add it. 

Grant the following permissions: 

REUSER = DBOwner or RE_ReadOnly

Default Schema = REUSER 

Save. 

PLEASE NOTE:


If you have your SQL server set to only use Windows Authentication, then the permissions above must be set for each SQL user accessing the RE database, not just for REUSER. If you are not using Windows Authentication, or are or are using mixed mode, for your SQL server, then setting the permissions just for REUSER should suffice.

2. Security\Logins\REUSER\Properties\User Mapping 

Map RE7 to REUSER and REUSER 

Save. 

3. If the above settings don't correct the error, then set up the custom connection in IOM 

Database = RE7 DB Name 

Server = Server Name in the SQL Server instance 

Username = REUSER 

Password = REUSER SQL Password 

*Note: The SQL Administrator can set up another User and Password for this custom connection. It does not have to be REUSER, though that's the default one RE installs and uses.

**If you are choosing another User Name, that User will also need the DBOwner or RE_ReadOnly permissions, as above.