Post reply

cannot create login user when using application role

  • February 19, 2012 at 9:40 pm

    #255934

    Hi !

    I create application role and grant all permission in database for it . but , when I want create new login and user in my application, I cannot, although i can select, update in my database.

    Notes : i tryto use create login or sp_addlogin, but all cannot.

    Help me, how to grant permission create user and login to my application role .

    Thanks before.

  • February 21, 2012 at 8:26 am

    #1449740

    ducvancong (2/19/2012)

    Hi !

    I create application role and grant all permission in database for it . but , when I want create new login and user in my application, I cannot, although i can select, update in my database.

    Are you trying to create a new server login and a new database user while in the context of an Application Role? I am not sure you can do that given that an Application Role is a database principal and your server login context is not available when in the context of an Application Role. You can hop in and out of the Application Role context though using sp_setapprole and sp_unsetapprole. Does the login initiating the Application Role session have permission to create server logins? i.e. is it in the sysadmin or securityadmin fixed server role?

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

  • February 23, 2012 at 12:13 am

    #1450663

    I see.

    thanks for your help so much .

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

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