How to set Oracle session info thru a Universe connection?

[system]

@Frederik

Hi,

In my example we created an oracle procedure setsecurity() and set the connectinit parameter to:

begin setsecurity(’@VARIABLE(‘BOUSER’)’); Commit; end;

thanx for the BOUSER parameter

With this can you show me what your SetSecurity fuction\procedure looks like ?

Thanks

---

di652 (BOB member since 2005-02-24)

[alvin.abrenica]

Set ConnectInit property under Custom Parameters section of Universe Connection Properties to:
begin setsecurity(’@VARIABLE(‘BOUSER’)’); end;

Steps:

1. Open Universe
2. Click on File menue
3. Click on Parameters
4. Click on Definition tab
5. Select connection ( e.g. Oracle connection )
6. Click on property icon ( next to folder icon )
7. Find Custom Parameters