Database Administration (MOSC)

MOSC Banner

Why it is showing SYS user twice in dba_users_with_defpwd table after upgraded to 19c. ?

There are two SYS user is showing in dba_users_with_defpwd table. So please tell us what does it means and why it is showing. Please find below output.


select * from dba_users_with_defpwd;

USERNAME        PRODUCT

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

SYS

OUTLN

SYS          Oracle Hospitality Simphony

ORACLE_OCM

LBACSYS

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