Oracle Map with Oracle VPD enabled database
My backend Oracle database has VPD policy enabled. Everytime when my application request a database connection, I will execute a stored procedure to set up session context for VPD to work then returned database connection to the application. However, for Oracle MapViewer, I don't have control of creating database connection. I couldn't execute the same stored procedure for MapViewer queries. I found that in latest Oracle MapViewer, it has a security feature which allow you to put a parameter called plsql_package in your MapViewer datasource configuration. However, this solution requires you to use J2EE, SSO or a cookie, which my current application are not using. So my set_user procedure in plsql_package is never called. Do you know any other way which could allow me to run a PL/SQL stored procedure for each MapViewer database connection? Thanks!