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
Turns out to be an undocumented feature on some versions of Oracle. I
was running 8.1.7.0.0. where the error occured. I have upgraded to
8.1.7.3, and was able to drop the user. I tried the same on a 9.2.0.1.0 and had the same problem. Apparently it works on 9.0 and 9.1.
claxton_at_networkessentials.com (John Claxton) 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 - 20:16:59 CST