Oracle Database Discussions

hi all!

my question is regarding synonyms , roles and users.

i have 3 users A,B,C.

user A has 5 objects v,w,x,y,z in its schema. Now i want to give select on the objects of A to B and C.

I create a role ROLE_A and grant select on A.v, A.w, A.x, A.y and A.z to ROLE_A and in the process grant ROLE_A to B and C.

now the problem is that users B and C have the SELECT on the objects of user A through the role ROLE_A.

i want to create synonyms on the objects of A.

Should i need to create private synonyms from both the user accounts (B and C)?
Should i create a public synonym for the objects of A?

What are the pros and cons of two ways?
Does the second method jeopardize the security of the database?


How do we create synonyms so that B and C can access the objects as v,w,x,y,z and not A.v, A.w, A.x, A.y, A,z?