Re: An issue of auditing DML operations

> One of the options might be creating package with variable containing
> your app username. For every call to database at first populate this
> vaiable and use it in your triggers. To make easier your job (and
> catch possible bugs :) you can use pragma serially_reusable for this
> package, it allows to populate variables only for one call and as soon
> as the call has finished variables are cleaned. So you won't get any
> unnecessary legacy from previous application user.
>
> Gints Plivnahttp://www.gplivna.eu- Hide quoted text -
>
> - Show quoted text -

Thank you very much. From another forum, I got a suggestion and I am trying with client_identifier attribute of userenv context.

Thanks,
Nirav Received on Fri Nov 23 2007 - 05:26:10 CST