Forum Stats

  • 3,839,376 Users
  • 2,262,486 Discussions


Constrain PDB datafiles into specific directory

Franck Pachot
Franck Pachot Member Posts: 912 Bronze Trophy
edited Jan 11, 2016 6:09PM in Database Ideas - Ideas


I like multitenant because it may be a good idea to give PDB DBA rights to the application owner (at least in dev/prod) so that they manage their database. But I can't do that for the moment because a PDB admin can create datafiles anywhere on the server, and that can be very difficult to manager.

A good idea would be to constrain a PDB to a specific directory (and subdirectories), so that all related files (datafiles and tempfiles) cannot go elsewhere. Then the CDB admin can give admin access to a PDB with the guarantee that he will not go outside of the assigned filesystem. Should be available for ASM as well.

I've seen a PDB_LOCKDOWN undocumented parameter that appeared in but I don't know if it is related to that. But would be a good name for it



Franck PachotUser_DGG74User259623 -OracleRichard Harrison .Geeky NerdmanDavid HueberUser_T3EKAnico_nijStew Ashtonhervedbi880720mdiIvica ArsovGugs-OracleErnst Leberuser11980779vinaykumar2pankajrangaPravin TakpirectriebManish ChaturvediTSharma-OracleKiran PawarLothar FlatzborneselphilippefJagadekarabhagatsinghMartin PreisscaadecarvalhoZlatko SiroticBPeaslandDBAulohmannSven W.Andreas BuckenhoferberxAparna Dutta-OracleBeGinMike RipleyThomas Teske-OraclePS_orclNerdGregVGbenga AjakayeMathias ZarickSri AnnamDaniel HillingerAndreas HuberShirish ReddyPeter HraškoLoïc Lefèvre-OracleEmad Al-Mousa
52 votes

Active · Last Updated