Re: SQL Domain Group Permissions
- From: "Richard Mueller [MVP]" <rlmueller-nospam@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 20:33:26 -0500
"hsmlives" <hsmlives@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
We have a new dba that is requesting domain admin access to perform tasks
like checking account operator roles and settings on computer accounts.
is a new request to me, but I definately don't won't to just hand over
admin access. Are there any specific high level sql admin access levels I
can give him to test out functionality? Is anyone currently doing this?
suggestions will be much appreciated.
The people know that are serious about security would never do this. I know
some that claim to manage domains with several hundred thousand users and
have maybe 2 or 3 members of Domain Admins.
Most settings can be retrieved by any authenticated user. Some computer
information retrieved using WMI might require administrator privileges on
the local PC. By default, the group "Domain Admins" is added to the local
Administrators group with the computer is joined to the domain. This allows
members of Domain Admins to retrieve more information on the computers.
However, you can grant someone the same privileges on computers by adding
some other domain group to the local Administrators group on all computers.
Make the dba a member of dba_Admin group, then make this group a member of
Administrators on all PC's, using Restricted Groups in Group Policy.
This still allows members of the new domain group to do great damage on
PC's, including spreading viruses, installing software, changing settings,
etc. There might be a better way to grant the dba the permissions they need.
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
- Prev by Date: Re: Impossible to use a view of a table from another database
- Next by Date: I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005
- Previous by thread: Re: Impossible to use a view of a table from another database
- Next by thread: I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005