Verify if I can use a given directory Admin creates an Oracle directory:

CREATE OR REPLACE DIRECTORY EXAMPLE AS '\\server\share\test';
GRANT READ, WRITE ON DIRECTORY EXAMPLE TO JOHN;


Admin can test whether the directory exists:

SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME='EXAMPLE'


How can John verify whether directory EXAMPLE exists? How can he find out what permissions he's been granted?
Permissions are exposed to a DBA in DBA_TAB_PRIVS.

SELECT * FROM dba_tab_privs WHERE table_name='EXAMPLE';


Your user John will be able to see his grants in ALL_TAB_PRIVS.