APEX

erw

Hi All

I have a table that contains role privilege, something like below

Action table

Action_id     Action_desc    

1                  Edit trans_dt

2                  Edit sysdate

Action_details

User             Role           action_id

SCOTT           IT                    1

I have a form that contain an item called trans_dt, What I want is that trans_dt only be updated/edit in such case  if user has permission to edit otherwise no edit allow on trans_dt..

Means if the current user has action_id=1 in action_details table then user can edit trans_dt otherwise not.

Regards

Matt