SQL> create user desarrollo identified by desarrollo;
User created.
SQL> grant connect, resource, create view, create materialized view to desarrollo;
Grant succeeded.
SQL> create materialized view test as select * from dual;
Materialized view created.
SQL> drop materialized view test;
Materialized view dropped.
SQL> begin
2 execute immediate 'create materialized view test as select * from dual';
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> desc test
Name Null? Type
----------------------------------------- -------- ----------------------------
DUMMY VARCHAR2(1)
SQL> drop materialized view test;
Materialized view dropped.
SQL> create procedure crea_mv_test as
2 begin
3 execute immediate 'create materialized view test as select * from dual';
4 end;
5 /
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "DESARROLLO.CREA_MV_TEST", line 3
ORA-06512: at line 1
SQL> create or replace procedure crea_mv_test authid current_user as
2 begin
3 execute immediate 'create materialized view test as select * from dual';
4 end;
5 /
Procedure created.
SQL> exec crea_mv_test;
PL/SQL procedure successfully completed.
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)