Re: ORA-01031:insufficient privileges on RENAME

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 18 Mar 2000 18:16:44 GMT
Message-ID: <8b0h6c$1ln$1@news.seed.net.tw>

Gennady <gennadyb_at_halcosoftware.com> wrote in message news:38d2ae6b$0$18401_at_fountain.mindlink.net...
> Hello,
> I connect to Oracle 8.0.5 DB as user with DBA privileges,
> then I change schema as :
> "ALTER SESSION SET current_schema = A;"
> Then I can drop a table in this schema, but when I try
> to RENAME a table in this schema I get the message:
> ORA-01031:insufficient privileges.
> Please, advise me how can I change my privileges to
> RENAME a table.

You must be the owner of the schema object to rename it. Received on Sat Mar 18 2000 - 12:16:44 CST