How to export DIRECTORY grants when exporting schema
How to export DIRECTORY grants when exporting schema
Schema SCHA has CREATE DIRECTORY privilege.
The directory is created but ALL_DIRECTORIES show owner as "SYS".
We grant READ,WRITE to SCHA on the directory.
When we export the schema how do we make sure the directories created by the schema user is also exported, together with grants?
Currently we're running a separate script which extracts this out of the data dictionary and into a generated script, but this is not ideal.
sr_786
Schema SCHA has CREATE DIRECTORY privilege.
The directory is created but ALL_DIRECTORIES show owner as "SYS".
We grant READ,WRITE to SCHA on the directory.
When we export the schema how do we make sure the directories created by the schema user is also exported, together with grants?
Currently we're running a separate script which extracts this out of the data dictionary and into a generated script, but this is not ideal.
sr_786
0