meathammer wrote:
> 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....
It stops 100% of IUD. Which sometimes is a good thing. And that's
why the business case is as important as the technology case.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jul 25 2006 - 05:24:35 CDT
