DB Instance

Question

Hello Team,

I am having 3 DB Instance in azure. I have 1 user and need to access to only 1 instance. How it can be done .Please advise me or let me know any link .

Thanks in advance

RK

Answer 1

Yes. You can assign user permissions only to a specific database and this is purely possible. Refer the following link

https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage#existing-logins-and-user-accounts-after-creating-a-new-database

Answer 2

If this is for Azure SQL then you can create non-admin database users and grant them access to the required databases only.

This can be done in the traditional manner with T-SQL or else using a management tool like SQL management studio.

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-login-transact-sql?view=azuresqldb-current&preserve-view=true#examples-1

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-ver15

Answer 3

You can also create a contained user which will only exist in the desired database ( no logins in the master DB)
basically you can use a syntax similar to : CREATE USER [YourUserName] WITH PASSWORD = [YourPassword]

see https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver15
and https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable