Re: Insufficient Privileges as system when dropping a user

satar..._at_hotmail.com wrote:
> If anyone can shed some light on this, it would be greatly
appreciated:
>
> irvsupu16 # sqlplus system/manager
>
> SQL*Plus: Release 9.2.0.5.0 - Production on Wed Apr 27 09:00:56 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Release 9.2.0.5.0 - 64bit Production
> JServer Release 9.2.0.5.0 - Production
>
> SQL> connect / as sysdba;
> Connected.
> SQL> drop user satar51 cascade;
> drop user satar51 cascade
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01031: insufficient privileges
> ORA-06512: at line 7
>
> SQL> connect satar51/satar51
> Connected.
> SQL> select table_name from user_tables;
>
> no rows selected
>
> SQL> connect system/manager as sysdba;
> Connected.
> SQL> drop user satar51;
> drop user satar51
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01031: insufficient privileges
> ORA-06512: at line 7
>
> Thanks in Advance!
>
> Regards...

It would appear you've installed a system package or procedure which should be owned by SYS under another user account, possibly SYSTEM. As such you are receiving the error message posted. Run catalog.sql and catproc.sql again, connected as SYS as sysdba. Then look for duplicate object names from the SYS catalog in other schemas and drop the duplicate objects, leaving the SYS schema intact. Then try your 'drop user satar51 cascade;' again. The user should be successfully dropped, presuming my assessment is correct.

David Fitzjarrell Received on Wed Apr 27 2005 - 22:57:15 CDT