Re: Strange user account problem

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Thu, 03 Oct 2002 12:16:13 -0500
Message-ID: <bjuopuoonkt8omqbno8m2rgoqqc2h1ngc1@4ax.com>

Creating one like that is not easy -

Use this to get rid of it:

drop user "song";

"Rahul Tikekar" <TikekarR_at_sou.edu> wrote:

>Using Oracle 8.1.5.
>
>Somehow I created a user 'song' (lowercase). Now I'd
>like to delete this user. So I say
>drop user song;
>
>Oracle replies:
>ORA-01918: user 'SONG' does not exist
>
>So Oracle is converting the user name to upper case and
>looking for SONG. But a user with the lower case song does
>exits. How do I tell Oracle to look for the lower case song
>and not SONG?
>
>Thank you.
>
>- Rahul Tikekar
>
>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Oct 03 2002 - 12:16:13 CDT