Can anyone give me info or the sites on forms6i security?
I am using Oracle9i and forms6i.
I have created some users accounts, roles and object privileges granted using Oracle Enterprise Manager and object privileges granted but need to apply it on forms (block level, items level...so Some users can view and edit and some users can view only.
All users are front end users (working with forms only).
Can someone point me to the right way plz.
Thank you in advance.
You can attach a library that checks/validates user roles. Every form references the attached library (pll file). Or, you can put the code in pre-form or when-new-form-instance at the form level trigger area that checks/validates user permissions.
You can create some roles that correspond to the privileges with respect to seeing blocks on the form.
Try to create roles that apply to all cases/types of users so you can set permissions at a higher level within the form, then at each block (when_new_block) all you have to do is check for true/false for existence of a role/permission.
The roles don't have to be actual database roles. You can create your own user role table and reference that table for better performance. Your table will have columns
username, role or datablock name, permission.
select information about a user into a cursor or record.
evaluate the roles the user has
set global flags (boolean) for each data block "role" to true or false
User calls the form, his permissions are evaluated at when_new_form_instance, and you set block properties. The blocks he can see are shown, the ones he can't use are hidden. If it is a block that doesn't appear initially, you put in a trigger that checks permission to see the block when_new_block_instance.