Hi,
I would like to set up row level security in APEX interactive grid.
As to display rows based on user who logs in.
Please let me know how can I get this for m APEX grid.
Thanks and Regards
Rukuiya
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
The table on which the interactive grid is based should have one more field, APPUSER. Now save the Oracle Apex :APP_USER whenever a row is created or edited.
Then you can use it in the where clause of the interactive grid to get the records for the current user. For example: