Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Admin loggin as another user

askMax - Maxime TremblayNov 10 2010 — edited Nov 10 2010
Hello

I was just wondering if there is a way to enable an application administrator to loggin as another user or to be able to change the username after loggin.

I was thinking about making a small function like this
CREATE OR REPLACE FUNCTION f_get_current_user
   RETURN VARCHAR2
IS
   IF v('NEW_APP_USER') IS NOT NULL
      RETURN v('NEW_APP_USER');
   ELSE
      v('APP_USER');
   END IF;
END;
And every where I'm user the :APP_USER substitution string, I would replace it with my function.

Did anyone ever do something like this?
Is there a better way to do this ?

Thanks
Max
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2010
Added on Nov 10 2010
6 comments
120 views