2 users, same schema

I want to create 2 users who have access to all the same tables, the only difference being that one owns the tables and has full access, while the other just has read-only access. So far, the only way I've found to do this is to have the administrative user "grant select" on each table to the read-only user, and then have the read-only user create synonyms for them all, like this:

• To be run as litmedadmin grant select on annot to litmed; grant select on work to litmed; [etc]
• To be run as litmed create synonym annot for litmedadmin.annot; create synonym work for litmedadmin.work; [etc]

Is there a simplier way to do this?
--

Roy Smith <roy_at_popmail.med.nyu.edu>
New York University School of Medicine
Copyright 1997 Roy Smith
For-profit redistribution prohibited Received on Sun May 25 1997 - 00:00:00 CDT