we are currently using 8.1.6 SE One and use a passwd protected role to protect our app data.
Following (unsolveable?) problem appears :
We are setting the role (SET ROLE FOO ...) in the app, and run a "ALTER SESSION SET CURRENT_SCHEMA=myschema".
When I try to access a view using package functions, I get "ORA-00904--Invalid Column name". The role has got select privileges on the view.
I have to grant all inner objects of the view to the user, and *whoops* ... it works (but I definitely dont want this).
If I grant the view to the role without altering schema and session, it works (?) by adressing the view via schema prefix.
What can I do? I have a layer of external views which shall be published to the role. I cannot afford opening all inner objects to the role by granting them (and is a direct conflict to a view-abstraction model).