q_directory

admin

--查询当前创建的目录

1. SET ECHO        OFF
   
2. SET FEEDBACK    6
   
3. SET HEADING     ON
   
4. SET LINESIZE    160
   
5. SET PAGESIZE    50000
   
6. SET TERMOUT     ON
   
7. SET TIMING      OFF
   
8. SET TRIMOUT     ON
   
9. SET TRIMSPOOL   ON
   
10. SET VERIFY      OFF
    
11. 
    
12. CLEAR COLUMNS
    
13. CLEAR BREAKS
    
14. CLEAR COMPUTES
    
15. 
    
16. COLUMN owner            FORMAT a10   HEADING 'Owner'
    
17. COLUMN directory_name   FORMAT a30   HEADING 'Directory Name'
    
18. COLUMN directory_path   FORMAT a85   HEADING 'Directory Path'
    
19. 
    
20. --directory info
    
21. 
    
22. SELECT owner, directory_name, directory_path
    
23.   FROM dba_directories
    
24. ORDER BY owner, directory_name;

复制代码

--查询目录的权限信息

1. clear columns breaks computes
   
2. 
   
3. column table_name    format a30 heading 'Directory Name' print entmap off
   
4. column grantee       format a30 heading 'Grantee'        print entmap off
   
5. column privilege     format a9  heading 'Privilege'      print entmap off
   
6. column grantable     format a9  heading 'Grantable'      print entmap off
   
7. 
   
8. break on report on table_name on grantee
   
9. 
   
10. select table_name, grantee, privilege, grantable
    
11.   from dba_tab_privs
    
12. where privilege in ('READ', 'WRITE')
    
13. order by table_name, grantee, privilege;

复制代码