DBA Hub

📋Steps in this guide1/1

Sec_case_sensitive_logon Parameter In Oracle

sec_case_sensitive_logon –  This initialisation(init) parameter enables or disabled password case sensitivity in the database.

oracle configurationintermediate
by OracleDba
24 views
1

Overview

sec_case_sensitive_logon –  This initialisation(init) parameter enables or disabled password case sensitivity in the database. When it is true , login passwords are case sensitive. if it is false , then login passwords are not case sensitive.  but Default value is TRUE.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
SQL> show parameter sec_case

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE



SQL> alter user TESTUSER identified by TESTpwd;

User altered.



SQL> connect TESTUSER/testpwd
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.



SQL> connect TESTUSER/TESTpwd
Connected.

SQL> ALTER SYSTEM SET sec_case_sensitive_logon=FALSE scope=both;

database altered.


SQL> show parameter sec_case

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

SQL> alter user TESTUSER identified by TESTpwd;

User altered.


Now try to connect with any case(small or caps)

SQL>
SQL> connect TESTUSER/testpwd
Connected.
SQL> connect TESTUSER/TESTUSER
Connected.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!