Re: ORA-01031: insufficient privileges on DBMS_REDEFINITION

Thanks Fraser

I was a little lazy when I said was unable to find it; I finally found that too in the admin guide I believe, but expected it to be in the pl/sql supplied package doco..

Rene

> Rene,
>
> Your user will also require:
> CREATE ANY TABLE
> ALTER ANY TABLE
> DROP ANY TABLE
> LOCK ANY TABLE
> SELECT ANY TABLE
>
> Kind Regards,
>
> Fraser McCallum
> MVP Oracle Administration
> www.brainbench.com
>
> "Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message
> news:a6d06107.0302250121.6574413_at_posting.google.com...

>> Hello
>>
>> On Oracle 9.2 I get an ORA-01031: insufficient privileges when
>> trying to execute
>> dbms_redefinition.start_redef_table
>>
>> As sys, I have granted execute on dbms_redefinition to the
>> user that needs that package. Obviously, this user needs
>> to have more privileges, but I am unable to find these.
>>
>> Can someone help.
>>
>> Thanks
>> Rene

-- 
  no sig today