We have answer of your question!

100% solved queries, no empty question

Question: sql 2005 roles


0

Advertisement


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.

Question author Larry-foulkrod | Source

Answer


1


Advertisement


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
Answer author Harpo

Advertisement


Tickanswer.com is providing the only single recommended solution of the question sql 2005 roles under the categories i.e sql-server-2005 , . Our team of experts filter the best solution for you.

You may also add your answer!