5 Replies Latest reply: Apr 5, 2013 9:28 AM by TSharma-Oracle RSS

    How to restrict public synonym for Schema

    Kishore 7284612
      I am having 2 schema with following details.

      Schema1 having 50tables with created public synonym for the tables.

      Schema2 having 10tables.

      Please advise to restrict access of public synonym from schema2. I want access only schema2 tables and should not access schema1 Tables.