Re: powerfull user

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

  • Next message: Emsga: "delete job" 
    Date: Tue, 27 May 2003 09:03:03 +0500

    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
    > >
    > >
    >
    >

  • Next message: Emsga: "delete job"

    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: 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)