RE: Read Only User

From: Peter Barnett <regdba_at_yahoo.com>
Date: Fri, 17 Dec 2004 08:03:43 -0800 (PST)
Message-ID: <20041217160343.84761.qmail@web13424.mail.yahoo.com>

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_at_yahoo.com> 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_at_allegientsystems.com> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>

---

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com                 

---

Do you Yahoo!?
Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com

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

Received on Fri Dec 17 2004 - 10:00:45 CST