Re: Want to run sp_addlogin

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 18:01:56 +0530

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

Relevant Pages

  • How can a non-owner start a job?
    ... There is a DTS package scheduled for execution every night as a SQL Server ... "Execute permissions default to the public role in the msdb database. ... who can execute this procedure and is a member of the sysadmin fixed role ... A user who is not a member of the sysadmin role can use ...
    (microsoft.public.sqlserver.security)
  • Re: Want to run sp_addlogin
    ... Sysadmin role membership is required to execute sp_addlogin. ... member login before executing the proc. ... not have the correct permissions to run the stored proc. ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... Execute permissions default to the public role in the msdb database. ... who can execute this procedure and is a member of the sysadmin fixed role can ... the SQL Server service is running. ... impersonation and sp_help_job is always executed under the security context ...
    (microsoft.public.sqlserver.security)
  • Re: Why does a client code need to be recompiled also?
    ... As far as what might have led him to write such a thing, even if his intended point was wrong, there are in fact restrictions on what you can put in a type's field initializer. ... The big no-no would be referring to any instance members, since the initializer is executed before _all_ of the constructors, so there's no safe way to ensure that an instance method would execute correctly. ... client code so that it performs the appropriate action, ... there's not any feasible way to create a single common method that handles access for a member both a field and a property. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... UpdateResearch stored procs. ... Resarch group (of which he is also a member), ... It's unclear to me why you explicitly denied execute on UpdateResearch to ... view-level permissions such that we can permit/deny a database action ...
    (microsoft.public.sqlserver.security)