SQL Server的实例，需要帮助来设置管理员权限 [英] instance of Azure SQL Server and need help setting up admin rights

问题描述

你们可以创建一个SQL Server Admin用户并将其分配给数据库吗?

解决方案

仅需注意:在Azure SQL数据库中，例如db_datareader，db_datawriter，db_ddladmin等角色是相同的传统数据库级别，但是在Azure SQL数据库中不存在诸如sysadmin，serveradmin等传统服务器级别的角色. /p>

请参考下面的链接并逐步进行操作...

https://www.mssqltips.com/sqlservertip/5242/将用户添加到Azure SQL数据库/

• 以SSMS作为管理员身份连接到Azure SQL数据库服务器.创建一个密码为"SuperSecret！"的SQL身份验证登录名"test"，并在数据库中创建一个映射到名为"test"的登录名的用户， 然后将其添加到db_datareader和db_datawriter角色.

-创建SQL从主 创建 与 = 超级秘密！" Im on Student Azure , and ( another account I have ) and was wondering about SQL DB. Im not using windows server, and im not planing authentication with Active Directory/ Windows for the user. I need a script, Shell command to be able to create a users / groups in the Microsoft Azure SQL screen.

I could not find any document online

解决方案

Hi,

Just a note : in Azure SQL Database roles like db_datareader, db_datawriter, db_ddladmin, etc. are the same traditional database level, but the traditional server level roles like sysadmin, serveradmin, etc. don’t exist in Azure SQL Database

Please refer the below link and do the step by step ...

https://www.mssqltips.com/sqlservertip/5242/adding-users-to-azure-sql-databases/

• Connect to your Azure SQL Database server with SSMS as an admin in master. Create a SQL authentication login called ‘test’ with a password of ‘SuperSecret!’, create a user mapped to the login called ‘test’ in a database, and then add it to the db_datareader and db_datawriter roles.

-- create SQL auth login from master 
CREATE LOGIN test 
WITH PASSWORD = 'SuperSecret!' 

这篇关于SQL Server的实例，需要帮助来设置管理员权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！