cannot connect the database user
Hi there ,
I am using Oracle Database 12.2.0.1 in Oracle Linix 7.8 platform. I am surprised that i am creating user with password but not able to connect the user next time. workaround as under:
SQL> CREATE USER TEST2 IDENTIFIED BY TEST2;
User created.
SQL> GRANT CONNECT,RESOURCE TO TEST2;
Grant succeeded.
SQL> CONN TEST2/TEST2
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn /as sysdba
Connected.
SQL> show parameter case
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
SQL> select USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS from dba_users