From oracle-l-bounce@freelists.org Mon Sep 19 14:03:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8JJ34rl015750 for ; Mon, 19 Sep 2005 14:03:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8JJ2w6H015733 for ; Mon, 19 Sep 2005 14:02:58 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0EE9E1EE720; Mon, 19 Sep 2005 14:02:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 13927-04; Mon, 19 Sep 2005 14:02:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8E02F1EE70B; Mon, 19 Sep 2005 14:02:47 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=B1wOTccIvYuA0dGmeEq3GMeOXSHCm5Fgw0aRO/Z4JR+NDmfXXs71akxx4at1oH3FmRYmc9+0JTpyXgY6r0Jw0xcCngZagqMjMckQz66TYQFnO/kc+aCSo1tgoNq7IrWrZXKY3acGQGGIEodb5G6ZBxAR0R6BtFpUhix2t6X0OQs= Message-ID: <9177895d0509191200742061be@mail.gmail.com> Date: Mon, 19 Sep 2005 15:00:56 -0400 From: rjamya To: "Gogala, Mladen" Subject: Re: Making a table readonly? Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24104_27421330.1127156456215" References: X-archive-position: 25646 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------=_Part_24104_27421330.1127156456215 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yup, the key is to own that trigger by sys, so table owner won't go, disabl= e=20 the trigger and mess with data. Along with this, you should however=20 incorporate auditing on this table to capture anyones attempts to mess with= =20 data. Raj On 9/19/05, Gogala, Mladen wrote: >=20 > Trigger would look something like this: > ------=_Part_24104_27421330.1127156456215 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yup, the key is to own that trigger by sys, so table owner won't go, disable the trigger and mess with data. Along with this, you should however incorporate auditing on this table to capture anyones attempts to mess with data.

Raj

On 9/19/05, Gogala, Mladen <MGogala@allegientsystems.com> wrote:

Trigger would look something like = this:


------=_Part_24104_27421330.1127156456215-- -- http://www.freelists.org/webpage/oracle-l