Re: sp_AddLogin

From: Tom Moreau (
Date: 03/24/03

From: "Tom Moreau" <>
Date: Mon, 24 Mar 2003 15:31:18 -0500

>From the BOL:

Only members of the sysadmin and securityadmin fixed server roles can execute sp_addlogin.

Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
"Aaron Barkel" <> wrote in message news:eUQBWOk8CHA.2272@TK2MSFTNGP12.phx.gbl...
What permission doesw a login need to perform sp_AddLogin. I keep getting
the following error.
Server: Msg 15247, Level 16, State 1, Procedure sp_addlogin, Line 17
User does not have permission to perform this action.