Re: powerfull user

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

Date: Tue, 27 May 2003 08:13:37 -0400

db_creator allows them to drop databases as well. I can't tell you which
role you should give this person as I am not sure exactly what you want them
to do or not do. I suggest looking thru the roles in BooksOnLine to find
the right combination but it sounds like you will not get what your after. 

-- 
Andrew J. Kelly
SQL Server MVP
"Usman" <jathol@hotmail.com> wrote in message
news:uJJLcVAJDHA.1584@TK2MSFTNGP11.phx.gbl...
> well
>
> if the if i make an ID which can create new DBs and do what he can with
> them.. not the old ones..
> it will also work ...
>
> should i give him the rights of "db creater"
>
> thanks
> usman
> "Andrew J. Kelly" <ajkellynospam@attbi.com> wrote in message
> news:udpKP64IDHA.3056@tk2msftngp13.phx.gbl...
> > 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: Connect to Client SQL
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... "Andrew Prior" wrote in message ... His server is set up ...
    (microsoft.public.sqlserver.security)
  • Re: powerfull user
    ... trust that they won't change the sa password? ... "Usman" wrote in message ... > but cant change sa password ... > what are the maximum rights.. ...
    (microsoft.public.sqlserver.security)
  • Re: Re: writing to a share during computer startup script
    ... >authenicated users and for anonymous logon. ... >Andrew Madsen wrote: ... I believe the Startup script runs under the system account, with no rights to shares. ...
    (microsoft.public.scripting.vbscript)
  • Re: kill idle process automaticaly
    ... no need to get admin rights... ... will simplye deleting the records will kill the processes ?? ... Usman ...
    (microsoft.public.sqlserver.security)