Re: How can I relate an Oracle Unix process to an oracle connection?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/18
Message-ID: <34eacc3f.16953517@www.sigov.si>#1/1

On 18 Feb 1998 08:09:19 GMT, "Dick Westeneng" <dwesteneng_at_baan.nl> wrote:

>To trace with Oracle connection was started by with UNIX pid I wrote the
>following structure:
>
>audit connect;
>
>create table user_proc_pid (
>
>...[SNIP]...
>
>But running this script gave the problem:
>create or replace trigger user_process_update
> *
>ERROR at line 1:
>ORA-04089: cannot create triggers on objects owned by SYS
>
>$ oerr ora 4089
>04089, 00000, "cannot create triggers on objects owned by SYS"
>// *Cause: An attempt was made to create a trigger on an object owned by
>SYS.
>// *Action: Do not create triggers on objects owned by SYS.
>
>This error
>Can anyone help me to create a trigger or something like that to see with
>users connects with pid?

[Quote from one of my previous posts]
The solution is described in "Tales from the Scripts", a collection of different utility scripts, provided from Oracle tech support, but officialy unsupported by oracle (use at your own risk). Look at http://support.oracle.com/cgi-bin/cr/getfile_cr.cgi?168430

As you can not create triggers on SYS's tables, create an auditing table AUD$ in the SYSTEM's schema! Create appropriate trigger on this table, drop the SYS.AUD$ table if it exists and create the SYS.AUD$ view, pointing to SYSTEM.AUD$ !
[/Quote from one of my previous posts]

You can then create trigger on SYSTEM.AUD$ table!

>Kind regards,
>
>Dick Westeneng
>BBO Baan Business Optimizations
>Office: +31 3 42 42 73 88
>Email: dwesteneng_at_baan.nl

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Feb 18 1998 - 00:00:00 CST