Avoid a synonym

I have a group of users that should only see a subset of data in certain tables. They share a role. I will create a view that implements that, and add it to their role. Then, to allow them to use the same queries as other users, I will have them individually create private synonyms that point to their views. Does anyone know of a better way, where each user won't have to create several private synonyms? This is Oracle 9i.  

Dennis Williams

DBA Lifetouch, Inc.

--
http://www.freelists.org/webpage/oracle-l