Database priviliges

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Wed, 25 May 2005 11:23:10 -0700 (PDT)
Message-ID: <20050525182310.9902.qmail@web51306.mail.yahoo.com>

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

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

Received on Wed May 25 2005 - 14:27:58 CDT