![]() ![]() in this example “TestDB1”) and grant permissions (i.e. In another query window in SSMS or Azure Data Studio which is connected to your Azure SQL Database Server, select the database for which you want to create the user (i.e. Switch the query window’s context to database “master” by switching to the “master” database from the database selection box in SQL Server Management Studio or Azure Data Studio.Ĭreate the login with the below T-SQL statement (you can change of course the login name and password accordingly in order to use a strong, secure password): - create SQL login in master database name it “ testLogin1“) and you would like to make this login a db_owner on database “ TestDB1“, then the process would be the below: Step 1: Connect as Admin to your Azure SQL Database ServerĬonnect to your Azure SQL Database server as an admin via SQL Server Management Studio or Azure Data Studio from on premises. So, if for example, you would like to create a new SQL login/user with db_owner permissions on a database, you can do this by connecting to the Azure SQL Database server via SQL Server Management Studio or Azure Data Studio and create the login and user with T-SQL statements.įor example if you would like to create a new SQL login on Azure SQL Database (i.e. This quick tip, talks about creating Azure SQL Database logins and users after you have performed an initial setup of your Azure SQL Database server and defined the admin user. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |