nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

database user access

Capuch

Hi guys,
I have a dataset which calls a procedure in the oracle database to access user@client, query as follows -

{call SI0WPR_SET_IDENTIFIER (?,?,?)}

where it takes a user, client and desc_client (output).

database procedure -

PROCEDURE "PE0WPR_SET_IDENTIFIER" ( in_userId varchar2 ,in_client varchar2 ,description out varchar2 ) AS

BEGIN

dbms_session.set_identifier(in_userId||'@';||in_client);

select distinct desc_client into description from sipe0wclienti where cod_client=in_client;

END PE0WPR_SET_IDENTIFIER;

The problem is that this method is not very efficient when i try to access tables through dynamic report parameters (lists) as it needs to access the dataset before executing the dynamic parameter.

Is there any way to pull this procedure into reportContext and initialise the report with the user access already granted to the database?

Thanks

Find more posts tagged with

Comments

mwilliams

Can you please elaborate on your last sentence that is describing what you'd like to do? Thanks!

Capuch

Hi MWilliams, thanks for the reply!

I'd like to be able to script the SP in beforeOpen of the dataset. The reason is because i have a dynamic list parameter which needs user access to secured views in a database that require the set_identifier procedure (which functions as the SP located in a SQL Stored Procedure Query dataset). The SP, however, runs after the parameter therefore not enabling the parameter list to work.

I was thinking to script the SP somehow to execute it in maybe the initialise report event to enable the dynamic list parameter to work.

Thanks