There’s not a lot of documentation regarding groups in Oracle Application Express, but I found an easy way to hide page elements based on group memberships.
Let’s say you have a form with a “Create” button, but you only want “power” users to be able to create records. Here’s an easy way to do it without having to write a lot of code:
Step 1: In the Administration dropdown for your application, select Manage Users and Groups. Select the Groups tab and then “Create User Group.” Call the new user group “PowerUsers.”
Step 2: Edit one of your users (or create a new one) by selecting the Users tab. Click the pencil next to a user and scroll down the User Groups section at the bottom of the page. Assign the user to the “PowerUsers” group and click “Apply Changes.”
Step 3: Edit the page with the form. Double click on the “Create” button and scroll down to the “Conditions” section. Change “Condition Type” to “PL/SQL Function Body Returning a Boolean” and add the following code in the Expression 1 code box:
declare val boolean;
val := apex_util.current_user_in_group(p_group_name=>’PowerUsers’);
That’s all there is to it! If you run the page logged in as a user that is a member of the “PowerUsers” group, the “Create” button will be displayed. If the current member is not a member of the “PowerUsers” group, the button will not be displayed.