Executing a package in my own schema when the current schema is different
This is a thread I had already raised in the former Metalink forum, but somewhat I didn’t get a satisfactory answer. This is more of a question than a problem actually. Here it is:
On Production instance, I connect with my personal user name GVANACKE which has limited privileges. There’s an AFTER LOGON trigger on my user that sets the current schema to APPS:
Connected to Oracle9i Enterprise Edition Release 9.2.0.6.0
Connected as gvanacke
SQL> select user from dual;
USER
------------------------------
GVANACKE
SQL> select SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') from dual;
SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
APPS