Provisioning

Configure user permissions for provisioning.

1. Users require the following permissions to perform provisioning operations:

   Copy

   go
   grant manage any login to [rolename]
   go
   grant manage server to [rolename]
   go
   grant manage roles to [rolename]
   go
   grant change password to [rolename]
   go

2. Configure user permissions to conduct database-related operations (add/remove user, add/remove database group, add/drop alias):

   Prerequisite: Service account must have associated user on respective databases and dbo must have manage database permissions privilege.

   Copy

   use [databaseName]
   go
   grant manage database permissions to [username]
   go
   use [databaseName]
   go
   grant manage any user to [username]
   go