When I create a new user and I assign server roles and database roles, what role(s) do I need to assign to this new user if I want this new user to be able to execute DDL and DBCC commands? I do not want to assign the same roles as the (sa) because that's too much power for this user.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create new logins with roles
- Thread starter khue
- Start date
tlbroadbent
MIS
You can assign the user to the db_ddlamin or db_owner role to enable DDL permissions. Some DBCC commands can only be used by a system admin. Others can only be executed by a database owner. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)
Home of the 2002 Winter Olympics (Feb 8-24)
- Status
Similar threads
- Locked
- Question