sql 2005 roles

Question

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.

Answer 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