Skip navigation

Constrain PDB datafiles into specific directory

score 470
You have not voted. Active

Hi,

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 12.1.0.2 but I don't know if it is related to that. But would be a good name for it

Regards,

Franck.

Comments

Vote history