APEX

Good afternoon,

I'm trying to setup an APEX application and I need to use the existing database security. I have pre-defined roles within the database that give users specific access rights based on which role they have been assigned. I have been able to setup my application to look for a database account and password for sign-in validation; however, the access rights seem to be based on the username that APEX uses to access the database.

For example:

role readonly has been granted access of select on the employee table.
role update has been granted access of select, update on the employee table.
role admin has been granted access of select, update, delete, insert on the employee table.

When a user logs in, I need to be able to use that database access security to determine what rights the user has within the application.
If a user logs in and the database role they were granted is readonly, then they should NOT have any update access anywhere in the application.

Is there a way of having APEX use those database roles to drive what access a user has within an APEX application?

Please help.


Thanks,
Don