Re: powerfull user

From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 05/26/03


Date: Mon, 26 May 2003 09:56:10 -0400


You will thrust this person to do anything they want to the db but you can't
trust that they won't change the sa password? In this case I don't think
you can have your cake and eat it too<g>.

-- 
Andrew J. Kelly
SQL Server MVP
"Usman" <jathol@hotmail.com> wrote in message
news:#$XESi2IDHA.3280@tk2msftngp13.phx.gbl...
> hi
> how can i create a powerfull user.. who can do any thing sa can do...
> create databases, etc..
> but cant change sa password
>
> what rights should i give him
>
> system admin ??
>
> please help..
>
> what are the maximum rights.. but cant change sa password..
>
> thanks
> Usman
>
>


Relevant Pages

  • Re: powerfull user
    ... should i give him the rights of "db creater" ... "Andrew J. Kelly" wrote in message ... >> but cant change sa password ...
    (microsoft.public.sqlserver.security)
  • Re: powerfull user
    ... "Usman" wrote in message ... > should i give him the rights of "db creater" ... > "Andrew J. Kelly" wrote in message ... >>> but cant change sa password ...
    (microsoft.public.sqlserver.security)