Application Roles and Views

[drdb]

Good Morning all

I have a program that uses three application roles across three databases. All of these roles have been tested and work untill I attempt to call a view. The view uses joins across two different databases. The user (even the dbo) gets an access denied message to one of the tables.

The error message says the access is denied for what ever local user is logged on the computer running the program, like it has somehow bypassed the app role.

If any has any ideas it would be great.
thanks

 

[NoCoolHandle]

<snip>
across two different databases.
</snip>

My guess is that your problem is all in the accross db thing. When you use application roles accross databases the user becomes 'guest' in that database. If guest/public doesn't have permissions the statement will fail.

HTH

Rob

 

[drdb]

Thanks Got It

Just took it out of a view and wrote direct sql statements and it works now.