如何让普通用户可以对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. tomcat启动web项目时候突然卡住
  2. 导致org.hibernate创建记录。MappingExce
  3. php RSA加密 JAVA 证书生成
  4. android与后台服务器的前后端通信
  5. java动态加载jar文件
  6. 003 恶补java运算(内容网摘)
  7. WebBrowser 遇到 javascript:void(0) 页
  8. IT兄弟连 JavaWeb教程 文件上传技术
  9. 读取Excel文件并跳过空行但不是空列
  10. Spring MVC-集成(Integration)-集成LOG4J示