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