2 Replies Latest reply: Nov 19, 2012 1:08 PM by EdStevens RSS

    SQL Dev anomolies

    EdStevens
      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-Oracle
          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
            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