Should I delete the NT/Admin's group in SQL Server 2k

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bruce Martin (anonymous_at_discussions.microsoft.com)
Date: 02/18/04


Date: Wed, 18 Feb 2004 04:42:06 -0800

I'm making my way through various books, white papers
etc, but I'm under the gun here so I'll ask here. We just
installed SQL2K, and I was elected DBA and head of
security. We are moving a bunch of internal applications
from Access to SQL2K. Everyone here is running either
Win2K or XP-PRO and are by default members of the
NT/ADMIN's group. The default SQL2K setup allows them to
log on with SA rights. I need them to be able to log on,
and do anything they want in PUBS, NORTHWIND, and
dca_conplan (new database) but not get to anything else.
So should I delete the NT/ADMIN group, and create a new
SQK2K group and assign the developers to that?

TIA

Bruce

And I will continue to RTFM.