Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
psangeetha
Yak Posting Veteran
95 Posts |
 Posted - 2008-08-19 : 14:20:34
|
| Hi all, My client would like to have the sp_setapprole implemented on the application, so the users can have full access to the database only when connected through the application. I am in the process of gathering knowledge about the application roles and how I can implement it. If you any of you have experience with the sp_setapprole or sp_addapprole, please give me your suggestions on how I can start with this. And, we use windows authentication to connect to the SQLserver database. I am not sure if it is possible to use the approle with it. Please let me know. THanks for your help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:59:17
|
| Yes, app role works with windows authentication. |
 |
|
|
|
|
|
approle