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

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

harshljica

 Profile Answers by harshljica Questions by 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.

Answer Question  Select Best Answer