From oracle-l-bounce@freelists.org Mon Jun 14 13:01:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5EI1m000615 for ; Mon, 14 Jun 2004 13:01:58 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5EI1c600555 for ; Mon, 14 Jun 2004 13:01:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B26C72CFFE; Mon, 14 Jun 2004 12:44:58 -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 18513-73; Mon, 14 Jun 2004 12:44:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7141C72D2D3; Mon, 14 Jun 2004 12:44:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 14 Jun 2004 12:43:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9563F72C19B for ; Mon, 14 Jun 2004 12:43:29 -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 18767-29 for ; Mon, 14 Jun 2004 12:43:29 -0500 (EST) Received: from venus.espn.com (venus.espn.com [204.149.192.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8EC572C141 for ; Mon, 14 Jun 2004 12:43:28 -0500 (EST) content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: How to revoke delete right from my own table Date: Mon, 14 Jun 2004 14:03:38 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to revoke delete right from my own table Thread-Index: AcRSOEBVkeFv+6psSZWdsO/tBAXNzwAAHoMgAABEzaAFrom: "Jamadagni, Rajendra" To: X-OriginalArrivalTime: 14 Jun 2004 18:03:39.0079 (UTC) FILETIME=[EB7EDD70:01C45239] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2694 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajendra.Jamadagni@espn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l From: oracle-l-bounce@freelists.org X-Virus-Scanned: by amavisd-new at freelists.org Sorry didn't finish my email completely ... ... Because if you own the table, you can't revoke privs from yourself. Raj ------------------------------------------------------------------------ -------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jamadagni, Rajendra Sent: Monday, June 14, 2004 1:56 PM To: oracle-l@freelists.org Subject: RE: How to revoke delete right from my own table Create a trigger on delete and raise exception ... Raj ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------