Hi Khalid,
You can get the OsUser Name and Machine Name and other details
from v$Session.

regards,
balaji.



-----Original Message-----
From: khalid qazi [mailto:[Email Address Removed] Friday, May 31, 2002 1:52 PM
To: LazyDBA.com Discussion
Subject: security related URGENT******


Hi All,

I am facing a security problem. Some regular user is trying to play with the
production database.

I have found out the culprit sql from v$sql. I wanted to know how can I
identify the machine name and address of terminal from which this sql was
fired.....................................


Regards,
Khalid Qazi
Tel : +91 (22) 652 8300 Ext 231
Fax : +91 (22) 397 8360




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
----------------------------------------------------------------------------
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended recipient
you should not disseminate,distribute,store,print, copy or deliver this
message.Please notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.E-mail
transmission cannot be guaranteed to be secure or error-free as information
could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or
contain viruses.The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a result
of e-mail transmission. If verification is required please request a
hard-copy version.
----------------------------------------------------------------------------
Oracle LazyDBA home page