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?
Permission failure when describing objects
Re: Permission failure when describing objects
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