Dear All,
Hope all of you are doing well,
Pls go through my problem...
here is an application developed based on Oracle Forms & Reports 6i.
I wrote a code, like for some specific Users, various permissions.
Ex: User A (Payroll Person), User B (HR)
for employee Master Data HR is the right person to modify master data and all the remain are not permissible.
I query one person (from Non HR user), try to modify Master Data then it given user defined message -
"you are not authorized person to modify Master Data" [OK] - so no changes done
then I clicked the Query button directly,
it gave the message - "Do you want to save the changes you have made" [Yes] [No] [Cancel]
when I clicked Yes :
" FRM - 40400 : Transaction complete : 1 records applied and saved "
In database also it is saving the record..
Mean for unotherised user also It's modifying the data.
Please help me the way to handle this issue..
Thanks in Advance...