-
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.
thanx with regards,
Raj
-
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.
junior
-
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.
Cheers
-
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?
---Raj
thanx with regards,
Raj
-
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
Vijay.s
-
Get their corresponding SID, Serial#, OSUSER from v$sesson to determine the different users.
-
ora_client_ip_address
VARCHAR2
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_
address;
end if;
select sys_context('userenv','ip_address')
from dual;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|