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?
Source control Problem: SELECT permission was denied
Re: Source control Problem: SELECT permission was denied
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:
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
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\
Re: Source control Problem: SELECT permission was denied
Version: dbForge Source Control for SQL Server 2.0.196
Standard edition
Standard edition
Re: Source control Problem: SELECT permission was denied
Thank you for the reply.
We will investigate this issue and will answer you as soon as possible.
We will investigate this issue and will answer you as soon as possible.
Re: Source control Problem: SELECT permission was denied
We have sent you a custom build with the fix by e-mail.