can we know history of previous SQL quries applied on the database from different user.like what all they do and which record is deleted by who with IP address of the user.
Can i get this info from ne of the data Dictionary tables or ne logs. thanx in advice.
if i am not wrong ..this can be achieved...but u need to turn on archiving and
also use the LogMiner utility by Oracle to trace any transactions by any users.
No, not really, not without auditing the user sessions. Another alternative is to set up an AUDIT table and and INSERT, UPDATE, DELETE trigger on the table/s you wish to monitor.
hi tthanx for attention ,one more this yet am not clear is that six clients using same Usernmae/passwd how to identify them (like gettng IP).will above fix this already?
u can find out the list of command fired from V$SQLTEXT. Take the hashaddress and find out the corresponding details from V$OPEN_CURSOR
Get their corresponding SID, Serial#, OSUSER from v$sesson to determine the different users.
Returns the IP address of the client in a LOGON event, when the underlying protocol is TCP/IP
if (ora_sysevent = 'LOGON')
then addr := ora_client_ip_