Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a Report based on different schema objects

bvankadariJan 6 2010 — edited Jan 6 2010
Hi,

I have a situation in creating Reports for my database performance.

Let me explain my requirment.

There are 2 schemas in my database called X, Y

X owns all the performance related data. But Y has read access on X objects.

Now in APEX I have a developer DEV1 is mapped to database schema Y through WS1.

I cannot map DEV1 to database schema X for security reasons.

When I am trying to create a report as DEV1, it is allowing me to create based on the objects owned by schema Y.

However it is not allowing me to create a report based on objects owned by X though Y has SELECT privileges on X's objects.

Can any one help in this?

Regards
Balaji
This post has been answered by jariola on Jan 6 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2010
Added on Jan 6 2010
#apex-discussions
8 comments
896 views