授予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";
  

查看存储过程

  grant debug ANY PROCEDURE TO APPREAD;
  

查看job和数据字典

  grant select_catalog_role to APPREAD;
  
  

在session里切换到userA用户

alter session set current_schema=userA;