Add Versioning Support for Directory Objects
It would be nice if SC for Oracle could add versioning support for directory objects and their privileges.
These are the directory objects that are created like this:
CREATE OR REPLACE DIRECTORY temp AS 'c:\temp';
and the list of directory objects comes from sys.alldirectories and their permissions from alltab_privs, like this:
SELECT alltabprivs.*
FROM alldirectories
JOIN alltabprivs ON (alltabprivs.tableschema = 'SYS' AND alldirectories.directoryname = alltabprivs.table_name);
8
votes
David
shared this idea