Query to check permissions on Directory

Run below query to find what kind of permissions have been given to directories to all schema/users in database.



SELECT *
  from all_tab_privs
 where table_name in (select directory_name from all_directories);