How do I view permissions for who can read/write DIRECTORY objects in oracle?
hi,
This is a little bit odd to ask but
I have at least two users that have read/write access to directory objects DBA_EXPORTS and AUDIT_EXPORTS. These directory objects belong to sys and sys has granted it to them. I run scripts that use these directory objects every day. Therefore the scripts are run by non-sys users (for safety) almost every day.
How do I confirm which users have the read or write to directory object permissions in database?
According to DBA_DIRECTORIES, both DBA_EXPORTS and AUDIT_EXPORTS directory objects are confirmed to exist and below to SYS.