Hi I have one schema in database named "A" Schema A has all of the database object like tables etc. Now I want to give Read only access for all Schema A Tables to "Sanjay" user. Is there any way that I can do without granting individually on table basis. What I am looking is full schema Read only kind of priviliges. Database is 9.2 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l