Re: Called by procedure or user?

Sounds like you want to audit the object. I believe you will get the username as part of the user_audit_object table.

Note: this will cause the procedure execution to slow alittle due to additional processing.

Rich.

oldhairy_at_my-dejanews.com wrote:
>
> Hi all,
>
> Is there a way to dynamically verify if a procedure/function is being
> called by an user (via SQL*Plus or Forms or any other client...) or by
> another procedure/function?
>
> No regular users own any objects, all procedures and functions belongs to
> the "application owner" and the users get access to them via roles. In our
> analysis phase we determined the only solution that will suit our needs is to
> find a way to verify if the procedure/function is being called by the client
> thus performing the security checks or by another procedure/function and not
> performing any security checks since we assumed it was done previously.
>
> We have checked the dynamic tabes (V$) but to no avail.
>
> Any ideas?
>
> Thanks, Ed.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 18 1998 - 07:52:05 CDT