5 Replies Latest reply on Apr 5, 2016 4:17 PM by a0e5c134-dda0-471b-99de-22035502b099

    unable to view under tables option

    a0e5c134-dda0-471b-99de-22035502b099

      Sql developer version used is 4.1.3.20

       

      I have created 2 users - op_user and ro_user. ro_user is part of readonly_role.

      I have few tables with owner as op_user. To expose these tables to ro_user, I have created a public synonym for each op_user table.

      ro_user can now login and run SELECT statements successfully against op_user tables.

      The issue is ro_user cannot view the tables under "Tables" (left pane) even after selecting Apply filter --> Include Synonyms option . However, ro_user can view the public synonyms under "Public Synonyms" option.

      Is this expected behavior or should ro_user be able to view tables with public synonym under "Tables" option?