5 Replies Latest reply: Nov 14, 2012 1:48 PM by dz_r RSS

    Unable to see TABLE data on SQL DEV

      Hi All,

      I am running version 3.1.07.

      Issue is:
      1) I connect to the database as user and am able to see the tables that belong to this user.

      However, when I do a " select * from table_name", no results come out but there are 4000 rows per row count.

      STRANGE thing is: when I am logged in as SYS user, I can issue the query:

      "select * from user.table_name" and I see the data set results with no issue.

      I have already provided all privs and even tried DBA role to no avail.
      Any ideas?