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 -> Drop user privilege

Drop user privilege

From: <pyates_at_my-dejanews.com>
Date: Tue, 20 Apr 1999 23:35:44 GMT
Message-ID: <7fj30g$mlq$1@nnrp1.dejanews.com>


Hi
I have just created an Oracle instance started nomount. Under user system I have created a few users but find I cannot drop them. I get the message :

drop user fred
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist

Have I forgot to run a setup script?

regards

Peter

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 18:35:44 CDT

Original text of this message

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