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 ?
ThanksAn 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment