0

I'm a newbie on SQL, I'd like to know how to create an extra account for Azure Sql Server that has all the permission granted.

It would be great if you could provide the SQL script.

Joseph Idziorek
  • 4,853
  • 6
  • 23
  • 37
huangcd
  • 2,369
  • 3
  • 18
  • 26
  • 1
    Please see the [Creating new user/login in sql azure](http://stackoverflow.com/q/6058058/4275342). I hope this will help – Roman Marusyk Oct 19 '15 at 10:00
  • Hi @MegaTron, I've tried to create both the login and user, as well as grant all permission using AUMC, but still no select permission. – huangcd Oct 20 '15 at 07:05

1 Answers1

0

The best way to achieve this is to use Azure Active Directory Authentication. When setting your Active Directory admin in the portal, choose an AD group. This way, any user who is a member of this group will have full administrator privileges.

tmullaney
  • 1,625
  • 9
  • 10