Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 4 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.

share|improve this answer
    
Oracle, always so intuitive. Thanks a lot, this is exactly what I was looking form. –  Álvaro G. Vicario Jul 31 '12 at 10:29
2  
@Á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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.