月度存档: 三月 2011

Oracle 11g New Feature – password case sensitive

##Case Sensitive Passwords in Oracle Database 11g Release 1
Case sensitive passwords (and auditing) are a default feature of newly created Oracle 11g databases. The Database Configuration Assistant (DBCA) allows you to revert these settings back to the pre-11g functionality during database creation.

SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

–when case sensitive passwords are not enabled, the original case of the password is retained so it can be used if case sensitivity is subsequently enabled.