create index

create or replace procedure mike.create_indexes as
begin
execute immediate 'create index mike.ixa on id (id)';
end;


exec create_indexes

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.
F.

mike needs to have explicit create index privilege not through roles.