Thanks for all the answers.
I tried showsql.sql and it helps a little. It means I have to run
this script quite often to see what's going on ( I might have
misunderstood some things here...? ).
Is it possible tomorrow or the next day to see what the OS-users did
today? The reason for me asking is this: we have some OS-users that
probably are doing some select-statements that they are not supposed
to do, and I want to see if it's true.
"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:<1QVF7.109037$%B6.29898145_at_typhoon.southeast.rr.com>...
> Do a search on Tom Kyte's website for a script called showsql.sql. It
> provides some pretty good info.
>
>
> "Sissel" <sissel_at_borgen.as> wrote in message
> news:c7d12b72.0111060627.75080e77_at_posting.google.com...
> > Hi.
> > I'm looking for å way to see which OS user does which
> > select-statements. I've tried TKPROF, but it didn't give me more
> than
> > Oracle-user ( at least as far as I could figure it out ), and that's
> > not enough.
> > Maybe a trigger would help, but I don't know anything about making
> > triggers.
> >
> > Thanks in advance.
Received on Wed Nov 07 2001 - 01:43:57 CST
