-1
I’m having trouble creating read-only users in SQL Azure.
He returns the message:
"The main server "****" is not Able to access the database "****" under the Current security context." Cannot open the user default database.
Can someone help me?
1 answer
0
Take a look at the documentation on Azure SQL Database - Access Control - Authorization. It explains possible permissioning types with Azure SQL Database.
To see the SQL instructions for making changes to these permissions, see this documentation about SQL - Security - Database Permissions.
Apply server-level permissions to login and database-level permissions users with the GRANT, REVOKE and DENY instructions. For example:
GRANT SELECT ON OBJECT::RecursosHumanos.Empregados TO Alessandra;
REVOKE SELECT ON OBJECT::RecursosHumanos.Empregados TO Alessandra;
See here several examples of how to recur permissions information.
Browser other questions tagged login windows-azure
You are not signed in. Login or sign up in order to post.