From oracle-l-bounce@freelists.org Mon Aug 22 20:23:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7N1Nj4Q014352 for ; Mon, 22 Aug 2005 20:23:45 -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 j7N1NhIP014341 for ; Mon, 22 Aug 2005 20:23:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB1961DF7BC; Mon, 22 Aug 2005 20:23:40 -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 05950-07; Mon, 22 Aug 2005 20:23:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E60D1D6623; Mon, 22 Aug 2005 20:23:40 -0500 (EST) X-IronPort-AV: i="3.96,132,1122872400"; d="scan'208,217"; a="19679805:sNHT44027025" X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5A780.F4349829" Subject: CREATE TABLE TRIGGER TO GENERATE "GRANTS" Date: Mon, 22 Aug 2005 20:21:13 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: CREATE TABLE TRIGGER TO GENERATE "GRANTS" Thread-Index: AcWnddtZ8JBUrb3CSLm8N9+c5xjqKAACnyLw From: "Wolfson Larry - lwolfs" Cc: "Oracle-L" X-OriginalArrivalTime: 23 Aug 2005 01:21:14.0288 (UTC) FILETIME=[F4195300:01C5A780] X-archive-position: 24321 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lawrence.wolfson@acxiom.com Precedence: normal Reply-To: lawrence.wolfson@acxiom.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.5 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5A780.F4349829 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="us-ascii" I saw this before and I'll be damned if I remember where. Someone had a nice trigger to generate and execute grants to roles that had update and select privileges so you wouldn't have to generate extra commands. Anyone have something canned before we go and write this? Thanks Larry Wolfson ************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ************************************************************************** ------_=_NextPart_001_01C5A780.F4349829 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset="us-ascii"

I saw this before and I’ll be damned if I remember where.

Someone had a nice trigger to generate and execute grants to roles that had update and select privileges so you wouldn’t have to generate extra commands.

Anyone have something canned before we go and write this?

Thanks

Larry Wolfson

**************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
**************************************************************************

------_=_NextPart_001_01C5A780.F4349829-- -- http://www.freelists.org/webpage/oracle-l