Source control Problem: SELECT permission was denied

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
entsu
Posts: 2
Joined: Tue 15 Oct 2019 13:08

Source control Problem: SELECT permission was denied

Post by entsu » Tue 15 Oct 2019 13:50

Hello

Regarding

While trying to do initial commit I get the following error:

Error The SELECT permission was denied on the object 'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'. Source Control: Myproject(Mydatabase.database.windows.net) 1

My database is an Azure SQL single database. I have root privileges but I also have tried with other users/logins without success.

I also have searched forum for answers, but the common suggestions do not help. IE I have tried the following to by example user 'dbdeveloper'

EXEC sp_addrolemember N'db_datareader' ,N'dbdeveloper'
GRANT SELECT ON sys.sql_expression_dependencies TO dbdeveloper

I still get the same error. So what spells should I cast to get this to work?

alexa
Devart Team
Posts: 2860
Joined: Fri 24 Jun 2011 14:17

Re: Source control Problem: SELECT permission was denied

Post by alexa » Tue 15 Oct 2019 17:26

Could you please provide us the full name of the product and its version?

Also, please install dbForge Studio for SQL Server, Enterprise Edition that includes the logging functionality https://www.devart.com/dbforge/sql/studio/download.html and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the issue and send us the *.log file with the latest date from the directory:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

entsu
Posts: 2
Joined: Tue 15 Oct 2019 13:08

Re: Source control Problem: SELECT permission was denied

Post by entsu » Wed 16 Oct 2019 05:27

Version: dbForge Source Control for SQL Server 2.0.196
Standard edition

alexa
Devart Team
Posts: 2860
Joined: Fri 24 Jun 2011 14:17

Re: Source control Problem: SELECT permission was denied

Post by alexa » Wed 16 Oct 2019 14:41

Thank you for the reply.

We will investigate this issue and will answer you as soon as possible.

alexa
Devart Team
Posts: 2860
Joined: Fri 24 Jun 2011 14:17

Re: Source control Problem: SELECT permission was denied

Post by alexa » Fri 01 Nov 2019 14:28

We have sent you a custom build with the fix by e-mail.

Post Reply