建立视图报 ORA-01031: insufficient privileges
来源:互联网 发布:爸爸网络词的意思 编辑:程序博客网 时间:2024/06/14 00:59
建立视图报 ORA-01031: insufficient privileges
建立所需要的实验环境的脚本:
create user lc0019999 identified by aaaaaa;create user lc0029999 identified by aaaaaa;grant dba to lc0019999;grant dba to lc0029999;create table lc0029999.t1 (c1 varchar(2));select * from lc0029999.t1;create view lc0019999.v_t1 as select * from lc0029999.t1;
进行如下实验:
F:\oracle\product\10.2.0\db_1\BIN>set oracle_sid=fsF:\oracle\product\10.2.0\db_1\BIN>sqlplus lc0019999/aaaaaaSQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 19 18:48:36 2015Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options18:48:37 lc0019999@FS>18:54:54 lc0019999@FS> create view lc0019999.v_t1 as select * from lc0029999.t1;create view lc0019999.v_t1 as select * from lc0029999.t1 *ERROR at line 1:ORA-01031: insufficient privileges --->报错!Elapsed: 00:00:00.0118:54:56 lc0019999@FS>
问题分析:
参考:ORA-1031 While Creating A View On A Table On Which The Select Privilege Is Granted Via A Role (文档 ID 271587.1)
In order to create a view in a schema, that schema must have the privileges necessary to either select, insert, update, or delete rows from all the tables or views on which the view is based. The view owner must be granted these privileges directly, rather than through a role. The reason is that privileges granted to roles cannot be inherited via objects, this is explained also in referenced note 168168.1.
解决方法:
Grant the select privilege on the base table directly rather than through a role:19:30:36 lc0019999@FS> conn lc0029999/aaaaaaConnected.19:34:22 lc0029999@FS> grant select on t1 to lc0019999;Grant succeeded.Elapsed: 00:00:00.0419:34:41 lc0029999@FS> conn lc0019999/aaaaaaConnected.19:35:19 lc0019999@FS> create view lc0019999.v_t1 as select * from lc0029999.t1;View created.Elapsed: 00:00:00.1819:35:49 lc0019999@FS>
0 0
- 建立视图报 ORA-01031: insufficient privileges
- 创建视图报ORA-01031:insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ora-01031:insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031:insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031:insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- ORA-01031: insufficient privileges
- 黑马程序员--JAVA学习笔记第四天
- 144.Binary Tree Preorder Traversal
- 使用Apache commons-httpclient获取上传文件的进度
- Struts2开发步骤
- Redis服务器学习笔记(一)
- 建立视图报 ORA-01031: insufficient privileges
- 搜索引擎的设计与实现(二)技术选型--全文索引
- 线上问题排查命令----Shell篇
- OGRE 阴影详解
- 剑指offer--面试题20:顺时针打印矩阵--Java实现
- opencv配置方式
- MySQL数据库的安装与配置(Windows)
- 我喜欢竞争
- Backbone.js 的最佳应用场景有哪些?