Database Administration (MOSC)

MOSC Banner

unable to connect to pdb with a local user

edited Dec 8, 2020 1:23AM in Database Administration (MOSC) 8 commentsAnswered ✓

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%');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center