Re: How to convert schema to readonly schema.

Along with the other good suggestions, you can open the database in read only 
mode too.

RF


 Robert G. Freeman
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com 
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
http://pages.sssnet.com/messndal/church/parachurch.pdf




________________________________
From: Avadhani mys <avadhanimys@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, June 22, 2009 5:57:34 AM
Subject: How to convert schema to readonly schema.

Hi Gurus, 

I have a requirement to convert schema to readonly schema. The application 
users should have select privilege on the objects he owns and application team 
would like to use this schema for reference. 

Thanks in Advance 
Aavadhani 

Other related posts: