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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User setup
- Thread starter kgreer
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
No one should ever use the sa account for anything. You should create accounts for each DBA (either SQL or domain based) and add them as members of the SYADMIN fixed server role.
Only the DBAs should be members of the SYSADMIN fixed server role. Everyone else on the server should have the least permissions needed to do there work.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Only the DBAs should be members of the SYSADMIN fixed server role. Everyone else on the server should have the least permissions needed to do there work.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question