CDB and PDB user question

Hello all,

The set up

Oracle 19c with pluggable database

cdbroot

pluggable

orclpdb

I have a common user:

c##super_cool

Im not understanding something. The alter session doesnt trigger a log in, in the PDB and even if the account is locked the user can still log in. I know that the alter session isnt technically a log in but it is registered as one in the audit trail.

SQL> sho user

USER is "C##SUPER_COOL"

SQL> sho con_name

CON_NAME

------------------------------

CDB$ROOT

SQL> SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL;

NOW