db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Period in username when using a DataSource
Date Thu, 15 Dec 2011 23:41:18 GMT
Trejkaz <trejkaz@trypticon.org> writes:

> Yet Derby doesn't appear to be doing this.  Is this a bug?

A username must be a valid SQL identifier in Derby. If you want to use
"."  inside one, you need to quite it. In Java, "\"john.smith\"", in
SQL, e.g in a GRANT statement: GRANT xxx TO "john.smith",

Note that quoted identifier must have the correct case (case is
significant then).

Hope this helps,

> TX

View raw message