6 Replies Latest reply: Apr 25, 2013 3:19 PM by rp0428 RSS

    User able to select the table,yet unable to fetch data..Strange!!

    DBA2013
      Hi Experts,

      I have a USER who is being granted a SELECT priv on particular table. He tried to fetch the data, but yeilds 0 bytes at the end..

      Here is a detail:

      GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
      ---------- ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
      UMA DNBPRIME DNB_SKAR_PEOPLE DNBPRIME SELECT NO NO

      SQL> connect uma/******

      Connected.

      SQL> select count(*) from dnbprime.dnb_skar_people where fragmentindicator = 1304;

      COUNT(*)
      ----------
      0

      For me it is quite strange, but I guess some security policy may be in place. But the issue is my client wants to fetch the data. What should I do Now.

      Regards,