Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 25026 invoked from network); 5 May 2006 12:59:14 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 5 May 2006 12:59:10 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1893A312C7E;
 Fri,  5 May 2006 13:56:10 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 21450-02-6; Fri, 5 May 2006 13:56:10 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DC57312C61;
 Fri,  5 May 2006 13:56:09 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 05 May 2006 13:55:27 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69FFE311FDA
 for <oracle-l@freelists.org>; Fri,  5 May 2006 13:55:27 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 21255-06 for <oracle-l@freelists.org>;
 Fri, 5 May 2006 13:55:27 -0400 (EDT)
Received: from ln-bas08.csfb.com (mx-2.csfb.com [198.240.128.81])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EEFD312A19
 for <oracle-l@freelists.org>; Fri,  5 May 2006 13:54:35 -0400 (EDT)
Received: from slon11p30742.csfb.cs-group.com (slon11p30742.csfb.mail [166.12.210.64])
 by ln-bas08.csfb.com (Postfix) with ESMTP id BF33F5CC4;
 Fri,  5 May 2006 18:53:47 +0100 (BST)
Received: from 166.12.48.43 by slon11p30742.csfb.cs-group.com with ESMTP
 (P30742L (Email Firewall v6.2.1)); Fri, 05 May 2006 18:53:40 +0100
X-Server-Uuid: 61CF3E3F-1AD5-4D04-8D72-51B8A5167142
Received: by slon00330.csfp.co.uk with Internet Mail Service (
 5.5.2655.55) id <JW9CVZ8K>; Fri, 5 May 2006 18:53:39 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF94152@ENYC11P32005.corpny.csfb.com>
From: "Baumgartel, Paul" <paul.baumgartel@credit-suisse.com>
To: "'BurtonL@frmaint.com'" <BurtonL@frmaint.com>,
 oracle-l@freelists.org
Subject: RE: DBA Role Privs
Date: Fri, 5 May 2006 18:53:36 +0100
MIME-Version: 1.0
X-WSS-ID: 68454EA90O8901338-01-03
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6706C.7E024658"
X-archive-position: 34294
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: paul.baumgartel@credit-suisse.com
Precedence: normal
Reply-to: paul.baumgartel@credit-suisse.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------_=_NextPart_001_01C6706C.7E024658
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit

You need a DDL trigger, not a table trigger.  Consult CREATE TRIGGER in the SQL manual and search for "ddl_event".
 

Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
DBA & Admin - NY, KIGA 1 
11 Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@credit-suisse.com 
www.credit-suisse.com 

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Burton, Laura
Sent: Friday, May 05, 2006 1:42 PM
To: oracle-l@freelists.org
Subject: DBA Role Privs



I want to be notified every time the DBA role is granted or revoked via email.  I found the procedure which takes care of the email.  Next I created a trigger on Insert into the Dba Role Privs view and received the error that this can not be performed on a view.  Does anyone know the underlying Sys table(s) to use, or a better way of checking this?

 

Thank you, 

Laura


==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

------_=_NextPart_001_01C6706C.7E024658
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = 
"urn:schemas-microsoft-com:office:office" xmlns:w = 
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
	COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
	COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
	COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
	page: Section1
}
</STYLE>

<META content="MSHTML 6.00.2800.1529" name=GENERATOR></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=938095117-05052006><FONT face=Arial color=#0000ff size=2>You 
need a DDL trigger, not a table trigger.&nbsp; Consult CREATE TRIGGER in the SQL 
manual and search for "ddl_event".</FONT></SPAN><SPAN 
class=938095117-05052006><FONT color=#0000ff size=2></DIV></FONT></SPAN>
<DIV>&nbsp;</DIV>
<P><B><FONT face=Arial size=2>Paul Baumgartel</FONT></B> <BR><B><FONT face=Arial 
size=2>CREDIT SUISSE</FONT></B> <BR><FONT face=Arial size=2>Information 
Technology</FONT> <BR><FONT face=Arial size=2>DBA &amp; Admin - NY, KIGA 
1</FONT> <BR><FONT face=Arial size=2>11 Madison Avenue</FONT> <BR><FONT 
face=Arial size=2>New York, NY 10010</FONT> <BR><FONT face=Arial 
size=2>USA</FONT> <BR><FONT face=Arial size=2>Phone 212.538.1143</FONT> 
<BR><FONT face=Arial size=2>paul.baumgartel@credit-suisse.com</FONT> <BR><FONT 
face=Arial size=2>www.credit-suisse.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> 
  oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]<B>On 
  Behalf Of </B>Burton, Laura<BR><B>Sent:</B> Friday, May 05, 2006 1:42 
  PM<BR><B>To:</B> oracle-l@freelists.org<BR><B>Subject:</B> DBA Role 
  Privs<BR><BR></FONT></DIV>
  <DIV class=Section1>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I want to be notified every time 
  the DBA role is granted or revoked via email.&nbsp; I found the procedure 
  which takes care of the email.&nbsp; Next I created a trigger on Insert into 
  the Dba Role Privs view and received the error that this can not be performed 
  on a view.&nbsp; Does anyone know the underlying Sys table(s) to use, or a 
  better way of checking this?<o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thank you, 
  <o:p></o:p></SPAN></FONT></P>
  <P class=MsoNormal><FONT face=Arial size=2><SPAN 
  style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Laura<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE>
<P><pre wrap>==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
</pre></P></BODY></HTML>

------_=_NextPart_001_01C6706C.7E024658--

--
http://www.freelists.org/webpage/oracle-l