Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: Application Role

    I am confused . What is considered an application and how SQL would know ?

    If I have a web site accessing SQL VIA IIS will SQL Server treat it as an application ? How about MS Excel ?

    Also , If I was to use the application of Power builder , using app role , how do control which user can use the app ?

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    An application role is activated for a connection by running the sp_setapprole stored procedure. The idea is you can activate the application role by putting the password in the compiled code of your application, while people using MS Access, and Query Analyzer can not get the same permissions because they do not know the password for the application role. Look up sp_setapprole in BOL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •