Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to restrict public synonym for Schema

Kishore BonthalaApr 5 2013 — edited Apr 5 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2013

Added on Apr 5 2013

#database-security, #database-security-general

5 comments

984 views