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-12-18 : 06:34:07
|
| Sergio writes "I am using Microsoft Access 2000 as a front end to an SQL 2000 database. I would like to use ODBC with a DSN and use a pass-through query to activate an application role.According to Microsoft, the best way to do this is to create a user-database role that denies SELECT, INSERT or UPDATE permissions on the relevant objects and add the user to that role. Then an application role is created with SELECT,INSERT and UPDATE permissions - when the application runs and the application role is activated, it gains pernmissions to access the objects.My problem is that if I use the above method I do not get access once I run the application unless the user role or the user has been granted permissions. Could this be due to the ODBC DSN needing these permissions?The reason I use ODBC is that I find linking the SQL tables to Access is the most efficient way. This cannot be done if OLE-DB or an ODBC DSN-less is used.Thanks for the help" |
|
|
|
|
|
Application role