Re: Make App "Read-only"

On Mon, 24 Jul 2006 16:15:08 -0400, meathammer <googler_at_google.com> wrote:

>Say I'm designing an app and I want to give admin of the app the
>option of making it READ-ONLY when he needs to.
>
>How will you do it ?
>
>How about this ? :
>Putting app tables into TABLESPACE_myapp so
>the admin can just do this:
> alter tablespace TABLESPACE_myapp read only;
>
>thanks
>

Apart from the horrible method, what pressing business need, if you already can get everyone out by
- enable the restricted_session privilege - stop the listener

Other than that: two roles would suffice one with select, insert, update, delete
and
one with select
revoke role1
grant role2
and hey presto.

--
Sybrand Bakker, Senior Oracle DBA