Re: ORA-01031: insufficient privileges on DBMS

From: Fraser McCallum <fmcc_at_nospam_odbaguru.com>
Date: Tue, 25 Feb 2003 20:45:23 +1100
Message-ID: <3e5b3994@usenet.per.paradox.net.au>

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
Received on Tue Feb 25 2003 - 03:45:23 CST

Re: ORA-01031: insufficient privileges on DBMS_REDEFINITION