Re: How to capture SQL_TEXT of queries?

Michael Ho wrote:
>
> Dragon Fly wrote:
>
> > how about setting up a trigger on some system table which gets
> > updated or inserted into whenever someone runs "SELECT" ??
> > which table(s) might be a good candidate?
>
> Maybe work, never try.
> But sounds too risky. I think a good DBA will never allow something
> like that happen.

don't worry, Oracle won't let you put triggers on system tables. I tried this once to trap when users logged in (using V$session table) and I could not put a trigger on it.

• Hank

-- 

netcom: henry_at_ix.netcom.com