Domain admin?

Hi,
Can I specify "read only" to one of one member of Domain admin? and still
keep Other Domain admin full access righrs. how to do that?
Thanks...
<<You can post this in the Security section for a definite answer but I
think
<<to do this you need to remove Domain Admins and Local Admins from your SQL
<<Server Logins or restrict the whole group to have lower access and then
give
<<more permissions to individuals.
Jeff Duncan
MCDBA, MCSE+I
"js" <js@.someone@.hotmail.com> wrote in message
news:eSc3ZerLEHA.3904@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I specify "read only" to one of the member of Domain admin? how to do
> that?
> Thanks...
>This is defined by granting access to the server. Remove domain admins
from the local admins if they are part of that group.
Add either individual nt users or create a new group and grant them
restricted permissions, like only select rights from a table. There is no
"read only " attribute for SQL. The closest thing we have is select access
to a view.
See this link for our best practices.
http://www.microsoft.com/technet/pr...n/sp3sec00.mspx
Hope this helps.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.