Post reply

create login

  • May 7, 2009 at 3:04 am

    #129864

    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

  • May 7, 2009 at 4:47 am

    #990218

    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!

  • July 27, 2010 at 3:39 pm

    #1199017

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply