Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insufficient Privileges as system when dropping a user

Insufficient Privileges as system when dropping a user

From: <satarnag_at_hotmail.com>
Date: 27 Apr 2005 09:48:44 -0700
Message-ID: <1114620524.221904.167860@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US