create index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: create index

  1. #1
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    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.

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    mike needs to have explicit create index privilege not through roles.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width