Hello,
Does anyone know, if you can pass through a unv and unx a user id down to an oracle database. we would like to be able to pass the user id down to an oracle database then drive security from oracle what tables and views they can use. We are currently on 4.2 sp6.
Thanks
Its only going to use the “BO_USER” for each data connection. No matter what the user id is for the person running the webi report.
Hello,
connection is usually done by a technical db user.
In the Connection you can specify a ConnectInit parameter e.g the following
ALTER SESSION SET CURRENT_SCHEMA = '@variable(‘BOUSER’)'
Have not tested this personally (Oracle right not installed here). But for Teradata and SQL Server we are using this procedure successfully…
Kind regards, Klaus
We do this using active directory network logins. Not sure how it works in Oracle, but it applies the correct security levels and allows the user to be fully audited and only see certain data.
Debbie