Can nay one tell me how can i set user permissions on form level to control user i.e i want to allow user1 only add permission and uer2 should have both add and edit permission how to do it on form level.
Set the Update property on your blocks, based on the user, in the When-New-Form-Instance trigger.
Of course, the decision as to what privileges to give which user should be based on a table (so the functionality would be table driven).
Here your menu newmaster will open a form for example,
We assue that name of ENTRY menu item is, ENT
AND name of new master menu item is NEWMST
so collectiveley we can say that new master menu item is ENT.NEWMST
Now we will have 4 table for example
usergroup (groupid, groupname,view, add , delete, edit, print) //here last 4 columns would be Y/N kind of columns
users (userid, groupid)
group_rights (menuid, groupid)
creat view which joins all above tables, to simply fetch information
You must track logged in userid,
Now in new form instance trigger, you may query your menuid and userid, to find add, delete, edit, print view flags)
or you may create database function with(menuid, userid, operation) which will return whether use has right of that operation or not.
It is giving message globel variable does not exists.
Can you make it in this way that user login t through login form and then it should check the user permission and then accordingly it should enable or disable the save,edit,search buttons. you can email me at email@example.com
When the user goes to user your first (Main Menu) form,
Oracle will automatically generate (present) a login dialog box.
There is no need for you to create one.
To get who the user is, use the "system variable" USER.