Home » SQL & PL/SQL » SQL & PL/SQL » Track the user
Track the user [message #21640] Wed, 21 August 2002 03:52 Go to next message
Santanu Goswami
Messages: 2
Registered: July 2002
Junior Member
How to track the user who executed a defined SQL command .

Thank You

Report message to a moderator

Re: Track the user [message #21660 is a reply to message #21640] Wed, 21 August 2002 14:15 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Are you trying to audit SQL statements run by users? In 9i you can audit select/insert/update/delete and ddl etc. Before that you can't track select statements. You can find sql statements in v$sql if thay are still cached.

Report message to a moderator

Previous Topic: Prefixed Indexes
Next Topic: Error 8177 BLOB Update more than 4k
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:51:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.