Different passwords for SQL Azure databases

Question

I have an Azure account within which I'm running 2 SQL Azure databases. Each database is housed under the same "SQL Server".

I wish to add a 3rd database, but I want to use a different login/password for this database. Is this possible without adding a new "SQL Server"?

You can read this https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins section #database-creators — e-Learner
This is not possible.In Azure,databases are grouped under a logical server.so when you create a database,it should be under some server — TheGameiswar

juunas juunas · Accepted Answer · 2017-02-15T07:09:23

The server in Azure SQL is essentially a management boundary. It provides the URL for the databases, as well as admin credentials. Whoever has those admin creds can manage every database within the server.

But if you want separate accounts, you can create them. Here's a few T-SQL statements that will create one:

--Connect to the Master DB
CREATE LOGIN Mary WITH PASSWORD = '<strong_password>';
--Connect to the DB you want to add the user to / Master if you are making an admin user
CREATE USER Mary FROM LOGIN Mary;
--Grant permissions, add to roles
ALTER ROLE db_owner ADD MEMBER Mary;

Read more here: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

Also note db_owner role can do anything in that database. You may want to make it a bit stricter. You can read more about SQL Server permissions here: https://msdn.microsoft.com/library/ms191291.aspx.

Different passwords for SQL Azure databases

1 Answers