Re: Called by procedure or user?

I saw a reference to the dbms_utility.format_call_stack. This may help, it was in the news groups about one week ago. Thomas Kyte of Oracle had posted a small routine to ID "who called me". I haven't looked at it closel, but it may do what you need.
HTH
   James

In article <6mbevc$qaf$1_at_nnrp1.dejanews.com>, 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
--

lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts