| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: logon trigger to start tracing
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------=_NextPartTM-000-f579896e-7d74-41d9-8de8-1fa0bd4efd32 Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C35124.CAF30C37"
------_=_NextPart_001_01C35124.CAF30C37
Content-Type: text/plain;
charset="iso-8859-1"
Paul,
remember it is a trigger ... so it runs under executing user's privs ...
Raj
-----Original Message-----
From: Paul Baumgartel [mailto:treegarden_at_yahoo.com]
Sent: Wednesday, July 23, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: logon trigger to start tracing
Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.
------_=_NextPart_001_01C35124.CAF30C37
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19">
<TITLE>RE: logon trigger to start tracing</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Paul,</FONT>
</P>
<P><FONT SIZE=2>remember it is a trigger ... so it runs under executing user's privs ... </FONT>
</P>
<P><FONT SIZE=2>1. everyone needs a direct grant for execute on dbms_session</FONT>
<BR><FONT SIZE=2>2. there needs to be a public synonym for dbms_session </FONT>
<BR><FONT SIZE=2>3. yell "Bingo!"</FONT>
</P>
<P><FONT SIZE=2>Raj</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Rajendra dot Jamadagni at nospamespn dot com</FONT>
<BR><FONT SIZE=2>All Views expressed in this email are strictly personal.</FONT>
<BR><FONT SIZE=2>QOTD: Any clod can have facts, having an opinion is an art !</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Paul Baumgartel [<A HREF="mailto:treegarden_at_yahoo.com">mailto:treegarden_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 10:59 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: logon trigger to start tracing</FONT>
</P>
<BR>
<P><FONT SIZE=2>Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C35124.CAF30C37--
------=_NextPartTM-000-f579896e-7d74-41d9-8de8-1fa0bd4efd32 Content-Type: text/plain;
name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="ESPN_Disclaimer.txt"
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1Received on Wed Jul 23 2003 - 09:14:56 CDT
 |
 |