Accessing DB through roles APEX interface
Having an issue with accessing (select,insert, update, etc) a database using roles in database while using Oracle's APEX.
Design of system is:
1) Object owner gives access to roles for the tables/views etc..
2) Other users/schemas in the database is given the selected role.
The above is the means of how the coding is to be done. Granting access from the object owner to the second user is not and acceptable solution.
What is the means of having accessing tables with roles while using APEX as the interface?
Thanks,
Floyd
Design of system is:
1) Object owner gives access to roles for the tables/views etc..
2) Other users/schemas in the database is given the selected role.
The above is the means of how the coding is to be done. Granting access from the object owner to the second user is not and acceptable solution.
What is the means of having accessing tables with roles while using APEX as the interface?
Thanks,
Floyd
0