When user opens the Database Browser, the plus (+) and minus (-) signs are missing for the 'Views', 'Indexes' and 'triggers'.
This happens when the user has 'SELECT ANY DICTIONARY' privilege, which allows the user to see other schemas' objects.
If user has this privilege, SQL Navigator should use 'DBA_dictionary' tables instead of 'ALL_Dictionary' tables.
WORKAROUND:
Create dummy objects in the nodes that are missing the (+) and (-) symbols. This will allow you to view the rest of your objects in that node.
STATUS:
Issue fixed in version 5.5.
The latest version of SQL Navigator for Oracle can be downloaded at the Support Portal.
Click here.
This is sue is very similar to CR0144700 that was fixed in version 5.1 (Solution 12820).
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center