This discussion is archived
6 Replies Latest reply: Apr 25, 2013 1:19 PM by rp0428 RSS

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

DBA2013 Newbie
Currently Being Moderated
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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points