我在一个数据库创建了两个用户一个dba_user,一个是connect_user,connnect_user有了create any table和create any view两个权限,并赋于dba_user里一些表的查询权限,现在我想在connect_user 里创建视图
create view test_view_1
as
select * from dba_user.table_name
这样就提示权限不足,请问一下,怎么才能在connect_user创建好视图
create view test_view_1
as
select * from dba_user.table_name
这样就提示权限不足,请问一下,怎么才能在connect_user创建好视图
SQL> show user
USER 为"TEMP"
SQL> create view vie_temp
2 as
3 select * from scott.emp;视图已建立。SQL> select * from vie_temp; EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- --------- ---------- ---------- ---------- ----------
DEPTNO
----------
7369 SMITH CLERK 7902 17-12月-80 800
20 7499 ALLEN SALESMAN 7698 20-2月 -81 1600 300
30 7521 WARD SALESMAN 7698 22-2月 -81 1250 500
..........................
..........以上说明了还要授权create session 的权限;
create or replace view connect_user.test_view_1
as
... ...