Re: execute immediate insufficient privilege error

From: <fitzjarrell_at_cox.net>
Date: Fri, 10 Aug 2007 07:08:38 -0700
Message-ID: <1186754918.833521.133320@x35g2000prf.googlegroups.com>

On Aug 10, 8:59 am, Faraz <sarfarazla..._at_gmail.com> wrote:
> HI all,
> I am trying to rebuild an index in a procdeure but some how getting
> the error below
> ERROR at line 1:
> ORA-01031: insufficient privileges
> ORA-06512: at "SCHD.CLEANUP", line 33
> ORA-06512: at line 1
>
> the owner of package and the index is the same user who invokes the
> procedure to do this task.
>
> any help will be appreciated.

Privileges granted through roles don't propagate to a stored procedure unless that procedure is compiled with authid current_user. This privilege is, most likely, granted through a role and not directly.

David Fitzjarrell Received on Fri Aug 10 2007 - 09:08:38 CDT