Re: Insufficient Privileges as system when dropping a user

satarnag_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...
>

Are you sure the patch was applied correctly? Have all required scripts been run, without errors?

Did you change the password file, or the value of the initialization parameter remote_login_passwordfile?

No errors in the alert log file?

If none of the above, you *could* try to run catalog and catproc again.

-- 
Regards,
Frank van Bortel