'What role to give a sql login in order to create a database and additional logins

What role should I give a sql login if I need the login to be able to create a database, and create additional logins and add users based on those logins to the database i created? This is sql 2005.

sql-server-2005


Solution 1:[1]

There is no fixed database role that includes these permissions. You'll have to create a role and assign the permissions individually.

CREATE ROLE db_creator
GRANT CREATE DATABASE TO db_creator
GRANT ALTER ANY LOGIN TO db_creator
GRANT ALTER ANY USER TO db_creator

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 harpo

Related Questions