alter session set current_user=<user you want to use) if your tables are in several users, then this won't work. -------------- Original message -------------- > 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 -- http://www.freelists.org/webpage/oracle-l