Re: Dropping a User with single-quote in the username

John Claxton wrote:
> 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

I just tried this in 8.1.7 and didn't get the error:

SQL> create user "LAST,FIRST" identified by junk; SQL> drop user "LAST,FIRST";

Did your system really change the comma (what you typed) to a single quote in the error message? Received on Fri Nov 08 2002 - 12:44:50 CST