Q: restrict other users

Hello,
I need to restrict other users to modify database including network
administrator. I go to permission tab and remove all checks and set
everything for my user but it seem administrator still have ability to modify
it.
How can I get only one user do everything and the rest have only read access?
Thanks,
Jim."JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:ADF936CE-5020-4CE0-A5E9-8C0EE086069C@.microsoft.com...
> Hello,
> I need to restrict other users to modify database including network
> administrator. I go to permission tab and remove all checks and set
> everything for my user but it seem administrator still have ability to
modify
> it.
> How can I get only one user do everything and the rest have only read
access?
> Thanks,
> Jim.
By default the BUILTIN\Administrators group is mapped to the sysadmin fixed
server role. To prevent this, first ensure that your user is mapped to the
sysadmin role, then either delete the admistrators login (stop them logging
in), or remove it from the sysadmin role. If everyone needs read access
then grant the appropriate permissions to the public role.
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004