itz the process address. try the following

select * from v$process where addr in (select address from v$sql)
select * from v$process where addr in (select child_address from v$sql)

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


Hi All,

Can anybody tell me whats "address" column in v$sql and how can I evaluate
it??????????????

Khalid

-----Original Message-----
From: Rahul [mailto:[Email Address Removed] Friday, May 31, 2002 2:02 PM
To: LazyDBA.com Discussion; 'khalid qazi'
Subject: RE: security related URGENT******


try to switch on auditing... or try to query v$session (if the user is still
connected)
to get the machine name etc.


> ----------
> From: khalid qazi[SMTP:[Email Address Removed] Sent: Friday, May 31, 2002 3:22 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] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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
>


--------
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
Oracle LazyDBA home page