Database Administration (MOSC)

MOSC Banner

How do I view permissions for who can read/write DIRECTORY objects in oracle?

edited Apr 3, 2023 2:03PM in Database Administration (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center