USER_tab_PRIVS能看到当前用户对那些目录有读写权限

SQL> select * from dba_directories;

OWNER        DIRECTORY_NAME       DIRECTORY_PATH

------------------------------ ------------------------------ ------------------------------------------------------------

SYS        DATA_PUMP_DIR       /oracle/product/10.2.0.1/Db_1/rdbms/log/

SYS        ORACLE_OCM_CONFIG_DIR       /oracle/product/10.2.0.1/Db_1/ccr/state

SYS        EXP       /oracle/exp

SYS        MYFILE       /oracle/myfile

SQL> grant write,read on directory myfile to scott;

Grant succeeded.

SQL> conn scott/tiger

Connected.

SQL> select * from USER_tab_PRIVS;

GRANTEE          OWNER       TABLE_NAME      GRANTOR     PRIVILEGE      GRA HIE

------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---

SCOTT        SYS       MYFILE      SYS     READ      NO  NO

SCOTT        SYS       MYFILE      SYS     WRITE      NO  NO

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27013009/viewspace-1263654/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27013009/viewspace-1263654/