All Apps and Add-ons

Splunk DB Connect and Oracle VPD (Virtual Private Databases): Is there a way to execute a stored proc to set a user context?



In my gathering of how Splunk DB Connect works, it appears it's not possible to execute a stored proc to set a user context.

Is there a way to support this in DB Connect?

I want to execute the following to set VPD context:


Any ideas how to get that working?

Thank you

0 Karma


The JDBC interface only allows simple DML commands: primarily SELECT. It does not allow for the execution of stored procedures or maintain session state between command executions. If you need to do something like this, then use a pipelined function to return the entire table, and include the dbms_session call as part of the function. You can then select from the function as follows:

select your_function() from dual;

There is information on pipelined functions here.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...

We’ve Got Education Validation!

Are you feeling it? All the career-boosting benefits of up-skilling with Splunk? It’s not just a feeling, it's ...