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?

BP9906
Builder

Hello,

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:

DBMS_SESSION.SET_CONTEXT('CLIENT_CTX', 'CLIENT_ID', V_CLIENT_ID);

Any ideas how to get that working?

Thank you

0 Karma

pmdba
Builder

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!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...