OBIEE 11g Repository Question: session context
The Metadata Repository Builder's Guide says in chapter 13, "Note: Alternatively, you can use the database session context to pass end user identity to the database. Use a connection pool script to set up session context. Note that this approach does not rely on database authentication."
However, no example or instruction is given to show/explain how to do that. Does anyone know how to set up a connection pool script to pass the :USER value to the database session context object? We have to pass the user ID of the Analytics user to the database so as to apply VPD policies.
Thanks,
Ken