Forum Stats

  • 3,758,932 Users
  • 2,251,475 Discussions
  • 7,870,439 Comments

Discussions

Can't log into PDB using common user creds

AbbY-OC
AbbY-OC Member Posts: 61 Blue Ribbon
edited Sep 20, 2021 4:51PM in General Database Discussions

Hello

I created a common user using

SQL> create user c##testuser identified by ******** container=all;
SQL> grant create session, dba to c##testuser container=all;


I can log into the CDB using the common user creds

$ sqlplus c##testuser/********
...
SQL> exit;


But when I try to log into the PDB using the same creds, it is failing with invalid username/password:

sqlplus c##testuser/*******@oudpdb1
...
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:


Checking the user for "COMMON" flag:

USERNAME	   PROFILE		 COM	 CON_ID
------------------ --------------------- --- ----------
C##TESTUSER	   DEFAULT		 YES	    1


This is a "Release 19.0.0.0.0" DB.


What is not set correctly?

Thanks,

Arindam

Tagged:

Answers