Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop user privilege
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