CODEWITHSUNDEEP
oracle-databasecontainersoracle12c
Kenny Tran
Kenny Tran

Reputation: 3

How to query show all pdbs in Oracle 12c with user normal

When i use query bellow to display pluggable in Oracle 12c with user "sys as sysdba"

select name from v$containers;

I displayed all pluggable. But when i connect with user normal. I display CDB$ROOT only. I want to use user normal to display all pluggable. what do I need grant permission for user normal to display all pluggable same as "sys as dba"?

Thanks a lot

Upvotes: 0

Views: 5736

Answers (1)

Mark Stewart
Mark Stewart

Reputation: 2098

Only users in the container database will be able to see pluggable databases; so you would need to create a user ID in the container database, and grant that user the role SELECT_CATALOG_ROLE and CREATE SESSION and then log into the container database with that new user ID, and you should be good.

By design and intent, users created in a pluggable database cannot see other pluggable database contents. That's one of the main benefits; isolation.

Upvotes: 1

Related Questions