Source control Problem: SELECT permission was denied
Posted: 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?
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?