dba_users view

Hi

When I tried this query--->desc dba_users or select username from dba_users;
I am getting this message___->ERROR:
ORA-04043: object dba_users does not exist


It used to work before but all of a sudden I got this error.

Any help would be appreciated to resolve this.

thanks in advance.
Smruti1Asked:
Who is Participating?
 
actonwangCommented:
you might lost this view by accident, try to run the following  script to restore it:

@<oracle_home>/rdbms/admin/catalog.sql
0
 
paquicubaCommented:
Are you connected as SYSTEM, SYS or have DBA role?
0
 
sathyagiriCommented:
Your DBA probably revoked your grant on the dba_ tables. Ask your DBA to assign the view catalog role to you.Then you shd be to access the dba_ views
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mohammadzahidCommented:
You can find out privileges currently enabled by running a query against SESSION_PRIVS view. This view will help you to determine exactly which privileges are currently enabled. And, you don't need DBA privileges to query this view.

0
 
Smruti1Author Commented:
Thanks to all for quick response.

I am connected as a  sysdba. I am the only one who is working as an Oracle DBA.

Thnaks in advance.
0
 
sathyagiriCommented:
Are you able to view any other DBA_ views at all?
0
 
Smruti1Author Commented:
Thanks satyagiri.

Yes, but not dba_users and dba_profiles.

Thanks in advance.
0
 
Smruti1Author Commented:
Thank you very much actonwang.

I ran catalog.sql script and now I am able to see dba_users view.


0
 
actonwangCommented:
COOL!
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.