RE: Read Only User
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 17 Dec 2004 08:03:43 -0800 (PST)
We have 'production support' databases which are
essentially clones of production. Reloading is
sometimes a pain but they are great for developer
trouble shooting without letting them get their hands
on production.
--- Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
wrote:
> Hi Mladen,
>
> Your suggestion is wonderful. It will make my life
> so much easier - I'll look after the read only
> account if you wouldn't mind dealing with the other
> 999 non-read only users on the system. Now what
> digits do you need to put in front of that 121
> extenstion? (just so I can add it to the application
> splash screen...)
>
> - Charlotte
>
> Mladen Gogala <MGogala@xxxxxxxxxxxxxxxxxxxx> wrote:
>
> The trick that will disable modifications from
> procedures is
> to do the following, logged in as SYSDBA:
> startup force mount
> alter database open read only
>
> Your read-only user will not be able to modify
> anything in the
> database, regardless of the procedures that he has
> access to.
>
> --
> Mladen Gogala
> Ext. 121
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Jazz up your holiday email with celebrity designs.
> Learn more.
>
> --
> //www.freelists.org/webpage/oracle-l
>
=====
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne@xxxxxxxxxxx
__________________________________
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
http://celebrity.mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
