授予hr用户查看执行计划权限（11g）

sqlplus / as sysdba
@?/sqlplus/admin/plustrce.sql

grant plustrace to hr;

conn hr/hr

HR@PROD>set autotrace traceonly;
HR@PROD>select count(*) from t3 where id=1;

只读表权限

  GRANT SELECT ANY TABLE TO "APPREAD";
  

        

          
        
        
        

          

          AI 代码解读
        
      
      

查看存储过程

  grant debug ANY PROCEDURE TO APPREAD;
  

        

          
        
        
        

          

          AI 代码解读
        
      
      

查看job和数据字典

  grant select_catalog_role to APPREAD;
  
  

        

          
        
        
        

          

          AI 代码解读
        
      
      

在session里切换到userA用户

alter session set current_schema=userA;