0 Replies Latest reply on Jan 17, 2017 7:24 PM by Rob Mutton-Oracle

    Some tables return no data.  Security profile setup in SQL dev??

    Rob Mutton-Oracle

      Hello,

       

      I have a problem where sql developer is not returning data from some tables..

      For example,  SQL> select * from fnd_lookups;

      The query results shows the column headings but no data.

      I also run select count(*) from fnd_lookups;  and it shows 0 records.

       

      However other tables  will return data.  e.g. SQL> select * from fnd_lookup_values;

       

      I can use SQL from a unix session and I can see data in the table.
      e.g. SQL> select count(*) from fnd_lookups;

        COUNT(*)
      ----------
           39368

       

      I have asked several colleagues to try it and all of them can see data from the table,  We all used the same instance, and user.

      The problem is specific to my install of SQL developer.

       

      I used autotrace when I query from the table I see the following.

      The only difference from my colleagues that don't have the problem is they only see the following "SECURITY_GROUP_ID=FND_GLOBAL"    while mine has the following:

       

      Are there any settings in SQL developer that I may have accidentally set  that enabled this security?

       

      Thanks

       

       

      TABLE ACCESS
      FND_LOOKUP_VALUES 39990 1705 6731 109233
             
      Filter Predicates
                 
      AND
                     
      VIEW_APPLICATION_ID=0
                     
      LANGUAGE=USERENV('LANG')
                     

      SECURITY_GROUP_ID=FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE,VIEW_APPLICATION_ID)

       

                     

      NVL(ZD_EDITION_NAME,'ORA$BASE')='V_20161220_2027'