Data Dictionary

How can we know the all tables and views that are given for the specific user(such as USER_VIEWS,USER_OBJECTS etc.)?

Questions by bhanumurthy03

Showing Answers 1 - 6 of 6 Answers

harshljica

  • Sep 2nd, 2009
 

Open dba_objects in that open column name owner, in that mention user name and it will display the list of tables and views of specific users.

  Was this answer useful?  Yes

asit

  • Jun 9th, 2012
 

Data dictionary is nothing but the place holder which contains all information of the object

like name,type,size,owner,permissions etc.

some data dictionaries : user_views,user_mviews, user_tabs, user_sequences, all_objects etc

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions