Hi,
I created a workspace in apex.oracle.com environment.
I have my user myname@mydomain.com to access in development environment.
I create an application, and a user environment to access with some privileges (I have a user table).
Now, I want to access to my application.
After login I display, in the home page region title, the username with: &APP_USER.
I can read the username (usr001) that I use to login.
If I run this SQL command : select v('APP_USER') from dual, the result is: myname@mydomain.com
I don’t understand.
This question is about my PL/SQL authorization function for each page.
I read a user table with this SQL sentence:
select col1, col2, …, colN
from users
where user_name = v(‘APP_USER’)
and if I don’t have the right results I can’t access to applications pages.
Many thanks for the help.