Re: SQL DBA Permissions

anonymous_at_discussions.microsoft.com
Date: 03/25/04 

Date: Thu, 25 Mar 2004 14:11:53 -0800

In an AD network, I am looking for a delegation of the
proper permissions. Are you suggesting that I just add
the DBA group to the local Power Users group on the SQL
Boxes? This is the description caption for Power
Users, "Power Users possess most administrative powers
with some restrictions. Thus, Power Users can run legacy
applications in addition to certified applications". See
my DBAs have domain admin right on the NT4 domain and are
used to certain things, but I want to revoke a good
portion of those rights, they do not need "god" rights, I
am that almost everyone understands why.
>-----Original Message-----
>On Thu, 25 Mar 2004 13:01:49 -0800, "Chris Lisi"
><anonymous@discussions.microsoft.com> wrote:
>
>>I want to avoid giving my SQL DBA enterprise/domain
admin
>>rights, has anyone setup a delegation for a SQL DBA that
>>gives them all the rights they need, to include
>>installation service packs, without giving them the keys
>>to the castle. Thanks
>
>Power Users doesn't get them what they need?
>
>Jeff
>.
>

Relevant Pages