What is the difference between all_ and user_ tables ?

Questions by Shweta_faqs   answers by Shweta_faqs

Showing Answers 1 - 8 of 8 Answers

  • An ALL_ view displays all the information accessible to the current user, including information from the current user's schema as well as information from objects in other schemas, if the current user has access to those objects by way of grants of privileges or roles.
  • While

  • A USER_ view displays all the information from the schema of the current user. No special privileges are required to query these views.
  •   Was this answer useful?  Yes

    Ashok kr. Choubey

    • Mar 4th, 2006
     

    User_tables data dictionary contains all the tables created by the users under that schema.

    whereas All_tables stores all the tables created in different schema. If any user id have the Grants for access table of diff. schema then he can see that table through this dictionary.

      Was this answer useful?  Yes

    The information available in data dictionary tables is very difficult to understand. So it provides views in a form that is easily  understood by users. All these views are owned by sys.

    Oracle provides three different type of views.

    USER_XXXX -> Objects owned by the user.
    ALL_XXXX   -> List of objects that user has access to
    DBA_XXXX -> List of all objects available in database.

    ALL_OBJECTS: Objects accessible to the user.
    USER_OBJECTS: Describes all objects owned by the current user.
    DBA_OBJECTS: Describes all objects in the database.

      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