Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Grant third party database schema a select Privilege on APPS schema MV's

edited Jun 21, 2023 8:20AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Dear All,

We are using EBS 12.2.12. We are integrating a third-party product with our EBS. We created database user for this third-party product.

This user needs to read data from inventory module (Items, locations), anyhow, from APPS schema we created MVs and granted select privilege on these MV's to the new user.

But when login using new schema and select from these MV's, no row returns.

How to grant third party database schema a select Privilege on APPS schema Object?

Thanks and regards,

Shareef

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