Devart Forums

Posted: **Tue 08 Jan 2019 16:22**

Hi, I just downloaded the trial version today and am getting this error when creating a new data comparison:

"Cannot describe an object. The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'."

I have sysadmin rights on the target database/server but only read rights on the source database. Does anyone have any suggestions?

Posted: **Thu 10 Jan 2019 09:18**

The user needs to be included into the db_datareader role. This can be achieved with the following script:

Code: Select all

USE <sourece_database_name>
GO
EXEC sp_addrolemember N'db_datareader' ,N'user_name'
GO

Devart Forums

Permission failure when describing objects

Permission failure when describing objects

Re: Permission failure when describing objects