what privilege needed for drop materialized view log
One of my user need to create any materialized view log, drop any materialized view log an alter any materialized view log. I granted the prilileges such as
grant CREATE ANY MATERIALIZED VIEW to testuser
grant ALTER ANY MATERIALIZED VIEW to testuser
grant DROP ANY MATERIALIZED VIEW to testuser
grant CREATE MATERIALIZED VIEW to testuser
The drop MATERIALIZED VIEW log is in a script through dynamic sql such as
execute immediate 'drop snapshot log on '||r1.owner||'.'||r1.table_name;
I got an error
Table: abc.mytest-----------------------------
declare
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 45
Any idea?
Thanks a lot!
Edited by: user12048533 on Nov 17, 2010 7:01 AM