unable to connect to pdb with a local user
I'm able to connect with system user. But when I create a local user and try to connect to the pdb, I get a ORA-01017: invalid username/password; logon denied
SQL> conn system/MNsd01asm@appl9pt7 as sysdba;
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> alter session set container = appl9pt7;
Session altered.
SQL> create user test1 identified by test1 container = current;
User created.
SQL> grant create session to test1;
Grant succeeded.
SQL> grant connect to test1;
Grant succeeded.
SQL> select username, PASSWORD_VERSIONS from dba_users where upper(username) like upper('%test%');