Setting UserAccess Control

In this blog post, I will explain how to assign a role at Application Access Control in Oracle APEX. Application Access Control is a feature that allows you to define and manage user roles and permissions for your APEX applications. By assigning roles to users, you can control what they can see and do in your application.

To assign a role to a user, you need to follow these steps:

1. 1. In to your APEX workspace and open the application that you want to manage. In the App Builder tab in your browser, select your application, in our case DEMO, you will be navigated to your Application page.

1. 1. Shared Components on your application home page. Shared Components in Oracle APEX are components that can be shared across multiple pages or applications. These components include templates (themes), list of values, navigation bar entries, shortcuts, plug-ins, authentication schemes and authorization schemes.You can access the Shared Components page by selecting an application and then clicking Shared Components

1. 1. At the Security section, Click Application Access Control.
      
      You’ll navigate to another page where you will set user roles and role assignments,
      
   2. Click on Add Role, and create a role for your application, then enter the name
      • Name: Administrator
      • Click Apply changes

      

   3. Then click Add User Role Assignment to assign a user to the role created.
      • Name: Test@gamil.com — this should be your email address that will be used at login page.
      • Then apply changes.

      

   4. 6. Then head back to shared Components page Click Authorization Scheme.
      Go to Authorization Scheme section:
      • Scheme Type: Is In Role Group
      • Type: Application Role
      • Name: Select the role create, in our case Administrator.
      • Click apply changes.

      

   5. Then head back to shared Components page Click List Values
      • Name: ACCESS_ROLES
      • Source Type: SQL QUERY

      
select role_name d, role_id r
from APEX_APPL_ACL_ROLES where application_id = :APP_ID
order by 1


Then apply changes, and your good to go.I hope this was helpful and informative.