This content has been marked as final. Show 2 replies
authentication is the process of identifying a user. What you need in addition is authorization, to check whether the user is entitled to use some resource (e.g. your application). In APEX, you can define authorization schemes that are e.g. based on a query against dba_role_privs for the current :APP_USER. Then you need to apply this authorizations, either at application level or to various parts of your application.