Post reply

Application role

  • December 1, 2008 at 7:34 am

    #202163

    Hi,

    How to add application role to user? can any one please tell me the step?

    Thanks

    MAnjula

  • December 1, 2008 at 7:41 am

    #905631

    Application roles aren't assigned to users.

    From Books Online:

    An application role is a database principal that enables an application to run with its own, user-like privileges. You can use application roles to allow access to specific data to only those users that connect through a particular application. Unlike database roles, application roles contain no members and are inactive by default. Application roles work with both authentication modes. Application roles are activated by using sp_setapprole, which requires a password. Because application roles are a database-level principal, they can access other databases only through permissions granted in those databases to guest. Therefore, any database in which guest has been disabled will be inaccessible to application roles in other databases.

    For more detailed information, please consult Application Roles in Books Online.

  • December 1, 2008 at 8:08 am

    #905652

    Thanks so much for your information

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

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