Post reply

Permissions needed for a application user to create a user login

  • February 17, 2011 at 1:16 pm

    #231409

    I have this crazy application that creates database logins from the application interface. What permissions do I need to assign the application user? I'm trying to avoid sysadmin at all costs. Would the securityadmin role be sufficient? Thanks in advance for your help!

  • February 17, 2011 at 1:39 pm

    #1288497

    If SQL 2005 or above you should look at using EXECUTE AS. You can create a stored proc that can create logins as needed as if a sysadmin was doing the work where the caller will not need elevated permissions.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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