Home » RDBMS Server » Security » looking for sql statements ran and date/time
looking for sql statements ran and date/time [message #244899] Thu, 14 June 2007 09:21 Go to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

Hi,
I'm looking for the list of sql statement and time when they were executed for
a single user in the system:
select * from v$ sql for example.
the problem is that v$ session can give me the last one.
thanks
Re: looking for sql statements ran and date/time [message #244917 is a reply to message #244899] Thu, 14 June 2007 10:26 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Only select statements ? or dml and ddl only?
if dml and ddl then start auditing.

[Updated on: Thu, 14 June 2007 10:28]

Report message to a moderator

Previous Topic: Problem with security and cross-schema foreign keys
Next Topic: Multi-tier auditing in Oracle from Business Objects
Goto Forum:
  


Current Time: Thu Mar 28 05:28:03 CDT 2024