Forum Discussion
ganriver
Mar 29, 2021Copper Contributor
Active Directory admin
Hi Friends, Risk assessment recommend to provision a 'Active Directory admin' for database, looked around, not exactly sure what is this for? and who should be better for this? Can someone ex...
ganriver
Mar 30, 2021Copper Contributor
and apparently, can only set one admin.
hspinto
Microsoft
Mar 30, 2021
Your DBAs should normally be the database admins. You can assign a Azure AD Group as admin. There is also the possibility of granting the db_owner role to other Azure AD users directly in the databases security model, but the recommended, much simpler way, should be using an Azure AD Group. See other additional considerations here.