Page 1 of 1
Permission failure when describing objects
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?
Re: Permission failure when describing objects
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
EXEC sp_addrolemember N'db_datareader' ,N'user_name'