create or replace procedure mike.create_indexes as
execute immediate 'create index mike.ixa on id (id)';
when I run this query as user mike, it returns I dont have privileges..?!?!?!?! I ran it using dbms_job, got error... I tried then to run it manually, calling the proc, and got the same error.
I have create procedure and create any index privilege.
thanks in advance.
mike needs to have explicit create index privilege not through roles.
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Click Here to Expand Forum to Full Width