deny users to see sa login SQL 2005

underprocessableCarlos
If I remember well you can disable 'sa' , check out BOL
"Carlos" <ca@.msn.es> wrote in message
news:%23YEy6fvvHHA.3588@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when a new user is created I execute next sentences:
> DENY VIEW ANY DATABASE TO user
> DENY ALTER ANY LOGIN TO user
> The new user cant see the other logins and databases, but he can see the
> "sa" login. Can I change this?
> Thanks
>|||Thanks Uri,
i've disabled sa and created a new user that belongs to sysadmin. Its
convenient that i change the db owner of the system databases to the new
user?
Thanks!
"Uri Dimant" <urid@.iscar.co.il> escribi en el mensaje
news:OdgICvvvHHA.4800@.TK2MSFTNGP05.phx.gbl...
> Carlos
> If I remember well you can disable 'sa' , check out BOL
>
> "Carlos" <ca@.msn.es> wrote in message
> news:%23YEy6fvvHHA.3588@.TK2MSFTNGP06.phx.gbl...
>