Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

create login Expand / Collapse
Author
Message
Posted Thursday, May 7, 2009 3:04 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, April 26, 2014 6:12 AM
Points: 88, Visits: 468
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
Posted Thursday, May 7, 2009 4:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 7:19 AM
Points: 1,113, Visits: 6,440
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
Posted Tuesday, July 27, 2010 3:39 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:27 PM
Points: 94, Visits: 1,461
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 »

Add to briefcase

Permissions Expand / Collapse