This discussion is archived
2 Replies Latest reply: Nov 19, 2012 11:08 AM by EdStevens RSS

SQL Dev anomolies

EdStevens Guru
Currently Being Moderated
SQL Dev 3.2.20.09
Windows 7 Pro.

I just installad SQL Dev on a power user's workstation and discovered a couple of things

1) - The tables and views folders in the navigation pane return nothing. If the same user connects with sqlplus and selects from ALL_TABLES and ALL_VIEWS, he gets the expected result.

2) - Well, now I am losing my mind ... I'll leave point #2 for later.
  • 1. Re: SQL Dev anomolies
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    The tables and views are filtered by your logon user.

    ALL_TABLES and ALL_VIEWS show every view and table in the database.

    You have to navigate down the connection tree to the 'Other Users' node, expand, and pull up your objects by owner/schema/user.

    For point #2 - this is normal :)
  • 2. Re: SQL Dev anomolies
    EdStevens Guru
    Currently Being Moderated
    Jeff Smith SQLDev PM wrote:
    The tables and views are filtered by your logon user.

    ALL_TABLES and ALL_VIEWS show every view and table in the database.
    Well, not every table/view in the database, just those the connected user has been granted access to. (ALL_TABLES vs. DBA_TABLES).
    You have to navigate down the connection tree to the 'Other Users' node, expand, and pull up your objects by owner/schema/user.
    Ah. You may dope slap me on this one. Of course ... the results under the navigation tree are going to default to USER_TABLES, not ALL_TABLES.

    For point #2 - this is normal :)
    And getting more normal with frightening regularity .. for me, anyway!

    Edited by: EdStevens on Nov 19, 2012 1:08 PM

Legend

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