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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-17 : 10:02:06
|
| Dave writes "Bill,A couple of years ago, you responded to an ADO/App_roles questions and said: "You should note that the use of AppRoles with ADO is problematic since the approles is strictly a SQL Server concoction that ADO is apparently not aware of or programmed to.In some cases ADO will create additional connections behind the scenes (especially when connections are 'busied') and since it doesnt know about approles they are not propogated automatically to the cloned connections. As a result, the new conenctions cannot access the database through the approle and would rely on whatever other access permisions the user had."Can you tell me what you mean by "In some cases..."? We are having an issue where I connect to our SQL Server 7.0 database through ADO, and can run queries on certain tables where I SHOULD have to set the app_role first. We have multiple servers (test, dev, etc) with the same databases on each, and the error will only occur on certain servers - the permissions are the same for the selected tables in SQL Server.If you could help me with this issue, or point me in the right direction, I would really appreciate it!!!Thanks for your time,Dave" |
|
|
|
|
|
App Roles Follow up