Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

private synonym

813348Jan 18 2011 — edited Jan 18 2011
hii i want to know that if i create a private synonym vinod_test_prv on a table vinod_test in hr schema and do not give select privilege on it but give privilege on the table can i select from the synonym in other schema say scott



create synonym vinod_test_prv for vinod_test;-- in hr schema

revoke select on vinod_test_prv from scott;-- in hr schema

SQL> grant select on vinod_test to scott;-- in hr schema

Grant succeeded.



scott schema

SQL> select count(*) from hr.vinod_test_prv;-- here i am able to select from synonym whereas i have revoked select from synonym

COUNT(*)
----------
107

Edited by: 810345 on Jan 18, 2011 3:50 PM
This post has been answered by Sven W. on Jan 18 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 15 2011
Added on Jan 18 2011
4 comments
1,367 views