Re: Which user executes my procedure?

Klim Samgin wrote:
>
> Hi, All!
>
> I've got PL/SQL procedure and I granted execute on it
> to some db users.
>
> Can my procedure to find out which user execute it?

Yes, this is how I used it once (that's an excerpt but I think it should run)

Christian

CREATE OR REPLACE
PROCEDURE test
IS

  user                  VARCHAR2(20);
  userid                INTEGER;
  df_tablename          varchar2(40);
  rej_tablename          varchar2(40);

• get userid and user for schema specification

  ---

  userid := UID; SELECT username INTO user FROM all_users WHERE user_id = userid; df_tablename := user||'.df_qrc'; rej_tablename := user||'.rej_warn_qsm'; END;