need to know the view who accessed the table last

[ramuv]

hi , i need know the view who accessed the table last, as some one has updated table with invalid data.

please can u let me know the view to identify the person who accessed the table last.

ram

[Bore]

Maybe you can do that by using the embedded auditing mechanism as well (not sure however)
To activate that, you should set the AUDIT_TRAIL init parameter and activate statement auditing issuing statement like
audit table ... by access;

Regards

[KenEwald]

Ram,

You're most of the way there if you know the table.

What version? Is your "User Of Interest" connecting through a connection pool?

-Ken

[gandolf989]

Did you try logminer???