Interesting Oracle Authentication Behavior

Tue, 30 Jan 2007 15:05:24 GMT

Oracle doesn't allow (by default) usernames that begin with a number, as well as certain special characters in usernames and passwords. After doing some research, I learn that Oracle will allow almost ANY username and password, as long as they are provided in quotes:

So, (in Java) this:
stmt.executeUpdate("alter user " + loginName + " identified by " + password);

Becomes this:
stmt.executeUpdate("alter user \"" + loginName + "\" identified by \"" + password + "\"");

No problemo. But there is a "gotcha"! When you add the quotes, usernames become CASE SENSITIVE!

Luckily for us, all of the usernames in this system are uppercase. so a quick addition, and you're good to go:
stmt.executeUpdate("alter user \"" + loginName.toUpperCase() + "\" identified by \"" + password + "\"");

I don't usually post Oracle stuff, but since there was so little information on this behavior, I thought I would share. Maybe it will help someone else out. :)

ColdFusion Developer Urgently Needed in Houston

Fri, 22 Sep 2006 11:47:00 GMT

ColdFusion developer needed ASAP in the Galleria area of Houston. This is a permanent, full-time position that will pay in the ~$60k range.

Required skills include ColdFusion and SQL Server, but they are growing quickly and value a diverse skill set for future need. Immediate availability is a big plus!

There is no significant travel.

They provide services in the income tax industry so there is a busy season before April 15th that will include significant overtime that will be balanced during the off season. There are bonuses available and good benefits.

Shoot me an email with your resume' attached if you're interested. My email address is my first name @ my full name (no underscored) dot com.

-Seth
(Mr. Bienek if you're nasty)

RSS feed for InstantSpot site cfguy

Interesting Oracle Authentication Behavior

ColdFusion Developer Urgently Needed in Houston