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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,699 views