Re: Want to run sp_addlogin

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/08/04

  • Next message: simo sentissi: "Maximum Memory for standart edition / enterprise" 
    Date: Thu, 8 Jul 2004 07:47:12 -0500

    You are right, Hari. I should have mentioned this role too. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:usohsjOZEHA.2432@tk2msftngp13.phx.gbl...
> Hi
>
> Logins with securityadmin fixed server role can also execute sp_addlogin.
>
> sp_addsrvrolemember  'login_name','securityadmin'
>
> --
> Thanks
> Hari
> MCDBA
>
> "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> news:eWFhGSOZEHA.3304@TK2MSFTNGP09.phx.gbl...
> > Sysadmin role membership is required to execute sp_addlogin.  If you
need
> to
> > execute this from application code, you can connect using a sysadmin
role
> > member login before executing the proc.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "sqldummy" <sqldummy@discussions.microsoft.com> wrote in message
> > news:6D87C2B5-091D-42B2-ACC6-12946DD9FFE4@microsoft.com...
> > > Hi there
> > > Is there a way, with which a user can run the sp_addlogin stored proc,
> if
> > they are not a member of db_owner.  We need some of them to add users
from
> > the applications, via a stored proce which calls sp_addlogin.  But they
do
> > not have the correct permissions to  run the stored proc.  Any help?
> > >
> >
> >
>
>
  • Next message: simo sentissi: "Maximum Memory for standart edition / enterprise"

    Relevant Pages

    • Re: Logging within User_Defined Functions (UDF)
      ... >>SQL Server MVP ... >>> I'm trying to carry out some logging each time an UDF ... Ultimately you can only execute ... >>> Only functions and extended stored procedures can be ...
      (microsoft.public.sqlserver.programming)
    • Re: Deadlock incidence greatly increased after upgrade from 11.5.1 to 12.5.3 - Suggestions?
      ... They may not execute simultaneously, but each user process only gets a ... Mike Epprecht, Microsoft SQL Server MVP ... >> Mike Epprecht, Microsoft SQL Server MVP ...
      (comp.databases.sybase)
    • Re: how to return the result of execute sql programmatically
      ... You can get the result through an Execute SQL Task, so no ned for ADO if you don't like it. ... I'd like to schadule the package in another server which my password of integrated security might not work. ... oExecSQL.SQLStatement = sSQLStatement ' Clean Up Set oExecSQL = Nothing ... Darren Green (SQL Server MVP) ...
      (microsoft.public.sqlserver.dts)
    • Re: Need help with SQL Statement
      ... declare @startdate smalldatetime ... insert logins ... >> SQL Server MVP ...
      (microsoft.public.sqlserver.datamining)
    • Re: sp_password
      ... SQL Server MVP ... "Leon Parker" wrote in message ... > Whenever I execute the procedure I get the error message that the ...
      (microsoft.public.sqlserver.security)