SQL & PL/SQL

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!

Accessing/Granting access to container DB tables from Pluggable DB and viceversa

$a!Sep 22 2017 — edited Sep 25 2017

Hi All,

I have oracle 12c installed and i have a container db schema(C##schema1) and a pluggable db schema(pdbschema).

I want to access tables of c##schema1 from pdbschema. How to achieve this.?

I have tried using the service name(c##schema1@orcl). But it didn't work(I suppose its a wrong way).

Also I want to grant permissions to pdbschema, so that any application that was logged into pdbschema can access c##schema1 tables.

I suppose the vice versa(accessing pdbschema tables from c##schema1) would also fall into the same explanation. If not, kindly suggest that approach too.

Regards,
Sail

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2017

Added on Sep 22 2017

13 comments

1,958 views