如何让普通用户可以对DBA_SOURCE视图进行闪回查询?  

 




赋权:  GRANT SELECT , FLASHBACK ON DBA_SOURCE TO LHR10;    
 
或:  GRANT DBA,SELECT_CATALOG_ROLE TO LHR10;  
 
 



LHR@orclasm > DROP USER LHR10;  
CREATE USER LHR10 IDENTIFIED BY LHR;  
GRANT RESOURCE TO LHR10;  








User dropped.  


LHR@orclasm >   
User created.  


LHR@orclasm >   
Grant succeeded.  


LHR@orclasm > LHR@orclasm > LHR@orclasm > LHR@orclasm >   
LHR@orclasm >   
LHR@orclasm >   
LHR@orclasm > CONN LHR10/LHR;  
ERROR:  
ORA-01045: user LHR10 lacks CREATE SESSION privilege; logon denied  




Warning: You are no longer connected to ORACLE.  
@ > CONN / AS SYSDBA  
Connected.  
SYS@orclasm > GRANT CONNECT,RESOURCE TO LHR10;  


Grant succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm >   
LHR10@orclasm > select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  
select * from dba_source as of timestamp sysdate -1/24 where rownum<=1  
              *  
ERROR at line 1:  
ORA-00942: table or view does not exist  




LHR10@orclasm > GRANT SELECT ON DBA_SOURCE TO LHR10;  
GRANT SELECT ON DBA_SOURCE TO LHR10  
                *  
ERROR at line 1:  
ORA-00942: table or view does not exist  




LHR10@orclasm > CONN / AS SYSDBA  
Connected.  
SYS@orclasm > GRANT SELECT ON DBA_SOURCE TO LHR10;  


Grant succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm > select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  
select * from dba_source as of timestamp sysdate -1/24 where rownum<=1  
              *  
ERROR at line 1:  
ORA-01031: insufficient privileges  




LHR10@orclasm > CONN / AS SYSDBA  
Connected.  
SYS@orclasm > GRANT FLASHBACK ON DBA_SOURCE TO LHR10;  


Grant succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm > select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  


OWNER                          NAME                           TYPE  
------------------------------ ------------------------------ ------------  
      LINE  
----------  
TEXT  
--------------------------------------------------------------------------------  
SYS                            AGGXMLIMP                      TYPE  
         1  
type AggXMLImp  




LHR10@orclasm > CONN / AS SYSDBA  
Connected.  
SYS@orclasm > REVOKE FLASHBACK ON DBA_SOURCE FROM LHR10;  


Revoke succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm >   
LHR10@orclasm >  select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  
 select * from dba_source as of timestamp sysdate -1/24 where rownum<=1  
               *  
ERROR at line 1:  
ORA-01031: insufficient privileges  




LHR10@orclasm > CONN / AS SYSDBA  
Connected.  
SYS@orclasm >   
SYS@orclasm > GRANT SELECT_CATALOG_ROLE TO LHR10;  


Grant succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm >  select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  
 select * from dba_source as of timestamp sysdate -1/24 where rownum<=1  
               *  
ERROR at line 1:  
ORA-01031: insufficient privileges  




LHR10@orclasm > CONN / as sysdba  
Connected.  
SYS@orclasm > grant dba to lhr10;  


Grant succeeded.  


SYS@orclasm > conn lhr10/LHR  
Connected.  
LHR10@orclasm >  select * from dba_source as of timestamp sysdate -1/24 where rownum<=1;  


OWNER                          NAME                           TYPE  
------------------------------ ------------------------------ ------------  
      LINE  
----------  
TEXT  
--------------------------------------------------------------------------------  
SYS                            AGGXMLIMP                      TYPE  
         1  
type AggXMLImp  


©著作权归作者所有:来自51CTO博客作者小麦苗DB宝的原创作品,如需转载,请注明出处,否则将追究法律责任

更多相关文章

  1. 物化视图快速刷新报 ORA-12008 & ORA-01031
  2. Eclipse的Servers视图中无法添加Tomcat6/Tomcat7
  3. 【MOS】Limitations of the Oracle Cost Based Optimizer (文档
  4. 【MOS】Redundant Interconnect ora.cluster_interconnect.haip
  5. 【MOS】Index Rebuild Is Hanging Or Taking Too Long (文档 ID
  6. 小麦苗数据库巡检脚本,支持Oracle、MySQL、SQL Server和PG等数据
  7. php实现多文件上传和mvc基础
  8. 【DB宝45】MySQL高可用之MGR+Consul架构部署
  9. Dynamics 365新特性介绍:在视图中显示图片和提示

随机推荐

  1. 在android真机上使用sqlite3
  2. 《Android/OPhone 开发完全讲义》已出版,
  3. Android 中文 API (23) ―― MultiAutoComp
  4. 启动emulator出错
  5. Android设置多个闹钟
  6. 64位win7操作系统 Android(安卓)开发环境
  7. android时区的初始化
  8. Android(安卓)Studio SDK 各版本下载方法
  9. Android客户端对服务端返回的xml文件内容
  10. Android处理9.png文件流程