| james |
Posted: Nov 20, 2007 01:44:25 AM |
Total Post: 2
Joined: Nov, 2007
|
| Report on users connected to db with IP & terminal in 10g |
|
|
 Mohammed Taj |
| Posted: Nov 20, 2007 08:48:47 AM |  |
|
Total Post: 709
Joined: Jul, 2007
|
select username,machine,terminal from v$session;
regards
taj
|
|
|
|
|
| james |
| Posted: Nov 22, 2007 06:58:48 AM | |
|
Total Post: 2
Joined: Nov, 2007
|
Hi! Taj
I think this query will not give the ip f the system.
thanx
jmaes
|
|
|
|
|
| MOH_DBA |
| Posted: Nov 26, 2007 01:16:00 PM | |
|
Total Post: 133
Joined: Nov, 2007
|
Try to make a database trigger that save every one who logged in the database and use this select to get the ip addresses for the sessions you want (select sys_context('userenv', 'ip_address') from dual);
I hope that helped
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
