Database Security Products (MOSC)

MOSC Banner

Local user entry is not added to the password file

edited Jun 17, 2025 1:34PM in Database Security Products (MOSC) 2 commentsAnswered ✓

Hi All,

I created a local user and granted him the administrative privilege (SYSDBA).

SQL> alter session set container=pdb1;

Session altered.

SQL> create user gaurav identified by g;

User created.

SQL> grant sysdba to g;

Grant succeeded.

⇒ When I check the v$pwfile_users, I do see his name there:

SQL> select username from v$pwfile_users;

USERNAME

SYS
G

⇒ But when I checked the password file:

[oracle@instance-2]$ strings orapwORCALL


][Z

ORACLE Remote Password file


jz;


[oracle@instance-2]$

⇒ Here I don't any user named G, why is this happening?

{INFORMATION REMOVED BY ADMIN}

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