Which Role(RABC) should I add to a user in Azure SQL to allow him access using SSMS?

0
votes

Im trying to grant users access to my Azure SQL, so they could connect using Sql Management Studio.

Which RBAC (role-based access control) roles should I assign them and How?

Thanks

2
azureazure-active-directoryazure-sql-databasessms
You do you require any special RBAC's to allow users to connect to a database as long as they have valid credentials and are authorized to connect to the DB instance . You would require group level (or user-level) permissions to create a mesh of priviliges to allow deterministic access to SQL objects such as views, tables, procedures et.al. - Raunak Jhawar

2 Answers

0
votes

When a new login and user created, they all could connect using SSMS, the difference is if the new user has the permission to access or alter the database.

Azure SQL database has administrator user and non-administrator user.

For more details, you can reference this document:Controlling and granting database access to SQL Database and SQL Data Warehouse.

You can grant the use different permission or alter it's role in database to control the access of Azure SQL Database with admin account.

Reference:

  1. ALTER ROLE (Transact-SQL).
  2. ALTER USER (Transact-SQL).

Hope this helps.