Improve company productivity with a Business Account.Sign Up

x
?
Solved

dba_users view

Posted on 2006-06-21
11
Medium Priority
?
2,721 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:Smruti1
  • 3
  • 2
  • 2
  • +3
10 Comments
 
LVL 23

Expert Comment

by:paquicuba
ID: 16956063
Are you connected as SYSTEM, SYS or have DBA role?
0
 
LVL 14

Expert Comment

by:sathyagiri
ID: 16956119
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
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 16956334
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 

Author Comment

by:Smruti1
ID: 16959514
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
 
LVL 14

Expert Comment

by:sathyagiri
ID: 16961076
Are you able to view any other DBA_ views at all?
0
 

Author Comment

by:Smruti1
ID: 16961206
Thanks satyagiri.

Yes, but not dba_users and dba_profiles.

Thanks in advance.
0
 
LVL 19

Accepted Solution

by:
actonwang earned 2000 total points
ID: 16961917
you might lost this view by accident, try to run the following  script to restore it:

@<oracle_home>/rdbms/admin/catalog.sql
0
 

Author Comment

by:Smruti1
ID: 16962075
Thank you very much actonwang.

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


0
 
LVL 19

Expert Comment

by:actonwang
ID: 16962165
COOL!
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20294455
Forced accept.

Computer101
EE Admin
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question