Get_Application_Property(USERNAME) and proxyuser
Hello,
I have a proxyuser setup and an appuser which has grant connect through proxyuser.
So, when connecting to forms , when we say proxyuser[appuser] for user field while logging into the db,
the Get_Application_Property(USERNAME) literally reads the user field and has value proxyuser[appuser] but desired is appuser.
Is there a way to override it and just get appuser like we see in other tools like Toad which shows appuser@db rightly and use the USER value.
Of course, i could do string manipulations or use USER value itself but its a lot of change for us, hence wanted to know.
Thanks.
Edited by: 902337 on Feb 11, 2013 8:11 AM
Edited by: 902337 on Feb 11, 2013 8:12 AM