This discussion is archived
5 Replies Latest reply: Apr 5, 2013 7:28 AM by TSharma-Oracle RSS

How to restrict public synonym for Schema

Kishore 7284612 Newbie
Currently Being Moderated
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.


Regards,
Kishore

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points