Hi All,
I created a local user and granted him the administrative privilege (SYSDBA). (19c database)
SQL> alter session set container=pdb1;
Session altered.
SQL> create user gaurav identified by gaurav;
User created.
SQL> grant sysdba to gaurav;
Grant succeeded.
⇒ When I check the v$pwfile_users, I do see his name there:
SQL> select username from v$pwfile_users;
USERNAME
----------
SYS
Gaurav
⇒ 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 Gaurav, why is this happening?