This discussion is archived
5 Replies Latest reply: Nov 14, 2012 11:48 AM by dz_r RSS

Unable to see TABLE data on SQL DEV

JCGO Newbie
Currently Being Moderated
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?

Legend

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