Authentication scheme using Database Accounts. That is, all users that are in the local database can access the system.
What you need to do to not all have access, and selectively? That is now in a database of about 25 people, with about 7 of them are active, the rest are either inactive or deleted. How to make access to these had only 7 people?
The fact that users do not have APEX and Oracle (from the database itself), so I came to the conclusion that it is necessary not to let inactive users in the application itself posing like "you do not have access," made it through the function to test was the flag (active or not (1, 0)), but it still does not work.
But maybe I'm doing something wrong ..
Created by the authentication scheme DATABASE ACCOUNTS has fields: Source (pl / sql code anonymous block), Session Not Valid, Login Processing. I write down their function in Source. But it did not work.
Why can it be?
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.