Database priviliges

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 May 2005 11:23:10 -0700 (PDT)

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

Other related posts: