Re: sp_AddLogin
From: Shannon Sheppard (dbashep@yahoo.com)
Date: 03/25/03
- Next message: Tom Moreau: "Re: sp_AddLogin"
- Previous message: Andrew J. Kelly: "Re: Restore SQL Security"
- In reply to: Tom Moreau: "Re: sp_AddLogin"
- Next in thread: Tom Moreau: "Re: sp_AddLogin"
- Reply: Tom Moreau: "Re: sp_AddLogin"
- Reply: Aaron Barkel: "Re: sp_AddLogin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Shannon Sheppard" <dbashep@yahoo.com> Date: Mon, 24 Mar 2003 15:08:55 -0800
I hope Aaron is having the same problem I am, and it does
not involve the obvious sysadmin and securityadmin. I am
getting the same error, but only on my people that are in
the securityadmin role, and only on a couple of databases
out of about 400 databases, I have two databases that are
getting this error, interestingly enough this started
after the SQL2000 SP3 rollout. ????
>-----Original Message-----
>>From the BOL:
>
>Permissions
>Only members of the sysadmin and securityadmin fixed
server roles can execute sp_addlogin.
>
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada tom@cips.ca
>www.pinnaclepublishing.com/sql
>
>
>"Aaron Barkel" <aaron_bar@hotmail.com> 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.
>
>
>
- Next message: Tom Moreau: "Re: sp_AddLogin"
- Previous message: Andrew J. Kelly: "Re: Restore SQL Security"
- In reply to: Tom Moreau: "Re: sp_AddLogin"
- Next in thread: Tom Moreau: "Re: sp_AddLogin"
- Reply: Tom Moreau: "Re: sp_AddLogin"
- Reply: Aaron Barkel: "Re: sp_AddLogin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
