Change the Password Version of user in Oracle 12c

Change the Password Version of user in Oracle 12c

Password Version of users depends upon the SQLNET.ORA file parameter value. For generating different version of password in Oracle database need to edit/choose the following parameter:

---For Generating all Password Versions 10G, 11G and 12c
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 or 11

---For Generating the 11G and 12c password Versions
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12

---For Generate only 12c Password Versions
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a

Check the current password version of user

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';
USERNAME  PASSWORD_VERSIONS 
--------- -----------------
C##SUNNY   11G 12C

Example show the Generate only 12c password version

--1. Modify the SQLNET.ora file with following parameter. SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
 SQL> alter user c##sunny identified by sunny;
 User altered.

--3. Show the password version
 SQL> conn c##sunny/sunny
 Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';
USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 12C

Note: 12 or 12a value in sqlnet.ora keep SEC_CASE_SENSITIVE_LOGON parameter to “TRUE” value.

Generate 11g and 12c password version.

 --1. Modify the SQLNET.ora file with following parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER=12

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
 SQL> alter user c##sunny identified by sunny;
 User altered.

--3. Show the password version
 SQL> conn c##sunny/sunny
 Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';
USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 11g 12C

Generate 10g, 11g and 12c password version

 --1. Modify the SQLNET.ora file with following parameter
 SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
 SQL> alter user c##sunny identified by sunny;
 User altered.

--3. Show the password version
 SQL> conn c##sunny/sunny
 Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';
USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 10g 11g 12C

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.