0 Replies Latest reply on Oct 29, 2013 11:54 PM by User456507-OC

    Query on SQL Developer Connections Tree Does Not Display Objects

    User456507-OC

      Hi Gurus, Could you please clarify on the below. As per the note ID 1458753.1, SQL Developer Connections Tree Does Not Display Objects to user in order to access database objects outside the owned schema/account. ------------------------- By default, and without granting wide privileges such as DBA, a user will only see his or her own objects in the first level object nodes under their connection.  Objects in other schemas must be accessed via the Other Users node under the connection. This is the intended functionality/display in SQL Developer. ------------------------- Is there any other way we can achieve this? Requirement is very common - user A owns all objects and user B granted read/read-write privileges on user A objects. Now user B wants to Display user A objects in the corresponding objects node of SQL developer. Could any one shed some light here? Thanks Venu