Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dropping a User with single-quote in the username
You didn't say what the OS or Oracle version was.
But, you might try a combination such as '"Claxton,John"';
The single, double quote should fix the recursive error.
"John Claxton" <claxton_at_networkessentials.com> wrote in message
news:2e257b19.0211080950.4a6d2ac3_at_posting.google.com...
> One of the developers at my site was using a tool to create database
> objects, including tables, users, etc. One of the users ended up with
> a single-quote as part of the username. i.e. Claxton,John. I have
> duplicated this with
> SQL> Create User "Claxton,John";
> However, when I try and drop the user
> SQL> Drop User "Claxton,John";
> I get:
> drop user "Claxton'John"
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00933: SQL command not properly ended
> ORA-06512: at line 7
> I've tried escaping the single-quote, double quoting the single quote,
> single-quotes, triple single-quotes, etc, etc, etc.
> All to no avail.
> Suggestions appreciated.
> jc
Received on Sun Nov 10 2002 - 10:33:58 CST