Re: powerfull user

From: Usman (jathol_at_hotmail.com)
Date: 05/28/03 

Date: Wed, 28 May 2003 11:21:26 +0500

thanks andrew ..
i'll look into the online biik

thanks for help

Usman
"Andrew J. Kelly" <ajkellynospam@attbi.com> wrote in message
news:#8CpllEJDHA.3604@tk2msftngp13.phx.gbl...
> 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
    ... "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)
  • 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: Multiple Access database connections
    ... Thanks, Andrew. ... set up a link for all the databases, so I'll try the dataset solution. ... >> model of Commands and Recordsets. ... >> on my refStateName table on databaseB. ...
    (microsoft.public.data.ado)
  • Re: Located databases no longer used.
    ... particular dband see if anything accesses them. ... Andrew J. Kelly SQL MVP ... > I'm looking to locate databases that have not been written to or accessed ... Is there a system table or stored procedure ...
    (microsoft.public.sqlserver.tools)
  • Re: database maintenance for companies that run 24/7
    ... Ken and Andrew, ... Isn't there fragmentation that also happens to the data on the ... Dan ... >> Do they have two databases and they switch back and forth? ...
    (microsoft.public.sqlserver.server)