Password Case Sensitivity in Oracle 11g

Oracle 11g now sets the password case sensitivity setting to TRUE by default. If you are running any application that connects to an earlier version of an Oracle database, chances are you are sending the connect string in all caps within the application (ex: USER/USER@ORCL11G when it really should be user/user@orcl11g). Make sure you are aware of this when developing your app and if the case is that you want to have case sensitive passwords, use double quotes to enclose the password string (ex: USER/”user”@ORCL11G). To disable password case sensitivity, just change the value of the system parameter sec_case_sensitive_logon:

alter system set sec_case_sensitive_logon = FALSE;

Where FALSE disables password case sensitivity and TRUE enables it.

Advertisements

Software developer. Currently working at MercadoLibre.com and other personal projects.

Tagged with: , , , , ,
Posted in Database Administration

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

%d bloggers like this: