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

Re: Drop user privilege

From: Rajan <sestri_at_hotmail.com>
Date: Tue, 20 Apr 1999 19:05:09 -0500
Message-ID: <371D1635.EB85BD41@hotmail.com>


Connect to sys adn run the script

pyates_at_my-dejanews.com wrote:

> 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 - 19:05:09 CDT

Original text of this message

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