Oracle Directory
select * from dba_directories;
Script di crezione di un directory dopo aver creato la directory sul file system
SQL> {CREATE | REPLACE | CREATE OR REPLACE} DIRECTORY alias AS 'pathname';Dove permission è:
READ
WRITE
ALL
ALL
Pr risalire ai privilegi concessi sulle directory
SQL> select 'Grant '||privilege||' on directory '||table_schema||'.'||table_name||' to '||grantee
from
all_tab_privs
where table_name in (select directory_name from dba_directories);