SQL & PL/SQL

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!

How can i confirm on SYSDBA role

chekkiligiliAug 20 2013 — edited Aug 20 2013

Hi Friends,

I want to confirm, whether i have SYSDBA role or not. I am able to connect through sql developer and i want to know this.

I tried this

SELECT * FROM v$pwfile_users;

but got response like below:

ORA-00942: table or view does not exist

00942. 00000 - "table or view does not exist"

*Cause:

*Action:

Error at Line: 1 Column: 14

can any one suggest?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2013

Added on Aug 20 2013

11 comments

1,009 views