5 Replies Latest reply on May 5, 2013 5:52 PM by EdStevens

    all_objects, dba_objects, user_objects

    707960
      hi guys, Please help me out about the difference between all_objects, dba_objects, user_objects.


      thanks
      shanthi
        • 1. Re: all_objects, dba_objects, user_objects
          SomeoneElse
          Goni's reading task for 7/10/2009:

          http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1001.htm
          • 2. Re: all_objects, dba_objects, user_objects
            sb92075
            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.
            http://tahiti.oracle.com
            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!
            • 3. Re: all_objects, dba_objects, user_objects
              709855
              hi shanthi,
              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.

              Regards,
              Muzafar
              • 4. Re: all_objects, dba_objects, user_objects
                1007177
                best one!!!
                • 5. Re: all_objects, dba_objects, user_objects
                  EdStevens
                  1004174 wrote:
                  best one!!!
                  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