Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Viewing users via V$PWFILE_USERS

474257Dec 28 2005 — edited Dec 29 2005
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2006
Added on Dec 28 2005
5 comments
5,844 views