create login

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » create login

create login

Rate Topic

Display Mode

Topic Options

Author

Message

bryan van ritter

Posted Thursday, May 07, 2009 3:04 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 01, 2013 12:35 AM
Points: 82, Visits: 443

Hi,

i am facing a problem in which someone wants to create logins and users for their database without having system or admin rights. is there a way of calling a procedure which creates the login as a user who has those rights to do so.

thanks in advance

bryan

Post #711842

Clive Strong

Posted Thursday, May 07, 2009 4:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:12 AM
Points: 959, Visits: 6,341

To create a login, you will need to have the "Alter any Login" permission granted to it. Either that or make the login a member of the securityadmin fixed server role.

Hope that helps!

Post #711881

Ryan D.

Posted Tuesday, July 27, 2010 3:39 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:43 AM
Points: 92, Visits: 1,270

In regards to the securityadmin role, doesn't this bring the issue of granting that user the ability the alter/remove any login from the system. I'm facing the similiar issue where a developer wants to permission rights to create logins on the server.

Post #959758

« Prev Topic | Next Topic »

Permissions