Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Map with Oracle VPD enabled database

626589Nov 21 2008
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2023
Added on Nov 21 2008
1 comment
475 views