Skip to Main Content

Database Software

Constrain PDB datafiles into specific directory

Franck PachotNov 12 2014 — edited Jan 11 2016


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



Post Details
Added on Nov 12 2014