I'm having trouble creating users with read-only access in SQL Azure.
It returns me the message:
"The main server" **** "is not able to access the database" **** "under the current security context." Can not open the default user database.
Can anyone help me?
Take a look at the documentation on Azure SQL Database - Control Access - Authorization . La explains the types of permissions allowed with Azure SQL Database.
To see the SQL statements to make changes to these permissions, see this documentation on SQL - Security - Database Permissions .
Apply server-level permissions to logins and users for database-level permissions with the GRANT, REVOKE, and DENY statements. 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 resort to permis- sion information .