Viewing users via V$PWFILE_USERS
474257Dec 28 2005 — edited Dec 29 2005I have installed a fresh Oracle 9.2.0.4. And I have created a database.
During database creation, I was asked the password of user SYS and SYSTEM.
I connected as user SYSTEM like this :
SQL> connect system/password as sysdba;
Connected.
Then I tried to view the privilege of users from V$PWFILE_USERS :
SQL> SELECT * FROM V$PWFILE_USERS;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE
Why it only contains SYS user ??? Where is the SYSTEM user ???
Because as you saw, I connected using SYSTEM and SYSDBA privilege
Thanks for any info.