Verify if I can use a given directory
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.