USERNAME Is Listed From V$PWFILE_USERS But Not From DBA_USERS (Doc ID 277740.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
Checked for relevance on 04-Sep-2010


Symptoms

A username is listed in V$PWFILE_USERS, but not in DBA_USERS :

SQL> select * from v$pwfile_users;
USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
U5                             TRUE FALSE
SQL> select count(*) from dba_users where username = 'U5';
COUNT(*)
----------
0

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms