Should I delete the NT/Admin's group in SQL Server 2k
From: Bruce Martin (anonymous_at_discussions.microsoft.com)
Date: 02/18/04
- Next message: Mukhtar: "SQL7 Sp4 install issue"
- Previous message: Keith Kratochvil: "Re: limits of SQL Server???"
- Next in thread: Mark Allison: "Re: Should I delete the NT/Admin's group in SQL Server 2k"
- Reply: Mark Allison: "Re: Should I delete the NT/Admin's group in SQL Server 2k"
- Reply: anonymous_at_discussions.microsoft.com: "Should I delete the NT/Admin's group in SQL Server 2k"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Mukhtar: "SQL7 Sp4 install issue"
- Previous message: Keith Kratochvil: "Re: limits of SQL Server???"
- Next in thread: Mark Allison: "Re: Should I delete the NT/Admin's group in SQL Server 2k"
- Reply: Mark Allison: "Re: Should I delete the NT/Admin's group in SQL Server 2k"
- Reply: anonymous_at_discussions.microsoft.com: "Should I delete the NT/Admin's group in SQL Server 2k"
- Messages sorted by: [ date ] [ thread ]