Permission failure when describing objects

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Phuong
Posts: 1
Joined: Tue 08 Jan 2019 16:07

Permission failure when describing objects

Post by Phuong » 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?

alexa

Re: Permission failure when describing objects

Post by alexa » 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

Post Reply