Is it different from the
Can anybody explain the process?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
The Server-Level Roles documentation says:
Members of the dbcreator fixed server role can create, alter, drop, and restore any database.
This obviously exceeds the ability to just "create any database" mentioned in the title of your question.
To add a login to the dbcreator role:
EXECUTE sys.sp_addsrvrolemember @loginame = N'LoginName', @rolename = N'dbcreator';
The process to grant only the permission
CREATE ANY DATABASE is as simple as:
-- Must be in master to grant server-scoped permissions USE master; GRANT CREATE ANY DATABASE TO LoginName;
It is generally seen as best practice to grant only the minimum permissions required.