Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insufficient Privileges as system when dropping a user
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... Received on Wed Apr 27 2005 - 11:48:44 CDT