Oracle Forms (MOSC)

MOSC Banner

Accessing DB through roles APEX interface

edited Jun 4, 2009 3:18AM in Oracle Forms (MOSC) 2 commentsAnswered
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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center