sql server msde: Administrators -- sql server msde

Administrators

Jose Nuñez
10/30/2004 11:11:09 AM

sql server msde:

I would like that local administrators or domain administrators dont have
administrative rights on some databases running with MSDE.

I've learned about to enable the user "sa" and to give a personal password
to this user, but apparently administrators continue having full access to
all databases.

Thanks.
Regards.
Jose Nuñez
Montevideo - Uruguay

Re: Administrators

Andrea Montanari
10/30/2004 5:15:14 PM

hi Jose,
"Jose Nuñez" <josenunez70@hotmail.com> ha scritto nel messaggio
news:OOeUxFovEHA.164@TK2MSFTNGP10.phx.gbl
[quoted text, click to view]

Hari already answered you in june.. http://tinyurl.com/4638l and gave you
additional pointers to troubles you could experience..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply