- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Common user in Oracle 12c
I would like about the recommendation ( or maybe even rule ) that says that common user should not own any objects ( tables for example ).
My question is :
Can common user create objects inside the root container. ? ( is that not possible or not recommended )
The scenario would be something like this :
There are more PDBs, and there is a need for some extra data, something like summary for all PDBs, to be stored somewhere outside any particular PDB.
For that purpose, I would create a common user ( because that one has to have access to all PDBs ), which will then create some tables and put that data there. But, if that can not be the root container, then, looks like I have to create another PDB just for that purpose.
Or there is some better way for doing this ?