How to find from the data dict if a user has read access on a directory

10-11  Source: Network gathering  Views:2 

Advertisement
How to find "dynamically" if a user has READ access to a directory object.
I want to know if there is a data dictionary table that holds if a user/schema has read access to a directory object.
I know there is an dba_directories table and an all_directories table but they dont give information as to which user has read access granted to the directory.
Not so difficult.
select  'YES'
   from all_tab_privs A, all_directories B
   where a.grantee = 'USERNAME'
       and a.table_name = b.directory_name
       and b.directory_path = 'PATH YOU ARE LOOKING FOR'
How to find "dynamically" if a user has READ access to a directory object.
I want to know if there is a data dictionary table that holds if a user/schema has read access to a directory object.
I know there is an dba_directories table and an all_directories table but they dont give information as to which user has read access granted to the directory.
Related articles