Hari, you really don't have the option of an Azure Active Directory login as you would with an on-premises server. If I got it right, we can add an AD account/security group to Azure SQL database in two ways :ġ) As an Active directory Admin from the portalĢ) As a contained user in a database, with the CREATE statement using EXTERNAL PROVIDERĪnd there is no concept of CREATE LOGIN in Azure sql database. In a database, and then add it to the db_datareader and db_datawriter roles. Of ‘SuperSecret!’, create a user mapped to the login called ‘test’ #CREATE DB IN SQLPRO STUDIO PASSWORD#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |