all_objects issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: all_objects issue

  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    33

    Question

    I have 4 main users in the database say oradba,spexdba,ctxsys & nfadba.
    When I execute the following query from oradba, the output is

    SQL> select count(*),owner from all_objects where status = 'INVALID' group by owner;

    12 CTXSYS
    1 NFADBA
    32 ORADBA
    1 SPEXDBA

    When I execute the same query from ctxsys, the output is
    SQL> select count(*),owner from all_objects where status = 'INVALID' group by owner;

    9 ADMACS_NFA
    26 CMS_NFA
    1 CTXDEMO
    54 CTXSYS
    16 NFADBA
    32 ORADBA
    2 SPEXDBA


    I thought all_objects view would list the objects, irrespective of whether you have access or not.
    Please let me know if I am right and what is the mistake I am doing in the above queries

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, ALL_* family of views will report only for the objects that you own or have been given acces to. DBA_* on the other hand will list *all* the objcts in the database.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width