Verify if I can use a given directory

Question

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?

Phil · Accepted Answer · 2012-07-31 10:13:58Z

up vote 3 down vote accepted

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.

answered Jul 31 '12 at 10:13

Phil
10.3k11334

	Oracle, always so intuitive. Thanks a lot, this is exactly what I was looking form. – Álvaro G. Vicario Jul 31 '12 at 10:29
	@ÁlvaroG.Vicario: an alternative is the view `ALL_DIRECTORIES` which shows all directories the current user has access to. – a_horse_with_no_name Jul 31 '12 at 12:16

1 Answer