This content has been marked as final. Show 5 replies
Goni's reading task for 7/10/2009:
It appears that whevever any question pops into your head, you post it here.
GOOGLE works! Use it!
Your answers are just a few clicks beyond the URL below.
Let us know when you have found your answer.
This site also has a functioning SEARCH capability. USE I!
When all else fails, Read The Fine Manual!
all_objects is show you all objects of current and those object which you have rights to access.
dba_objects show all object of all users .
user_objects show you the current user objects.
1004174 wrote:Not necessarily. It gave you the OP the immediate answer to your immediate question, but did nothing to help make you more self-sufficient by learning to use the documentation, or presenting the principles that you could apply to similar questions in the future
Here's a general principle:
In the naming of the fixed views,
DBA_anything lists all of 'anything' in the entire database
ALL_anything lists all of 'anything' that the user making the request has been granted access to
USER_anyting lists all of 'anything' that the user making the request owns
-- I just noticed that this was a reply to a very old thread. And for what? Just another argument in favor of the new forum automatically locking threads after a certain period of dormancy.
Edited by: EdStevens on May 5, 2013 12:50 PM
Edited by: EdStevens on May 5, 2013 12:51 PM