Re: Make App "Read-only"

On Mon, 24 Jul 2006 22:24:50 +0200, Sybrand Bakker wrote:
> 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
>

thanks syb,

but can you tell me what is so "horrible" about the method of making TS read-only ?

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

Does that stop packages from doing U/I/D ? since roles are not enabled in packages.... Received on Mon Jul 24 2006 - 15:36:19 CDT