| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: security without using different usernames
Hi
You can get the ip address as follows:
oracle:jupiter> sqlplus system/manager_at_emil
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
SQL> select sys_context('userenv','ip_address') ip,username,machine
2 from v$session
3 where sys_context('userenv','sessionid')=audsid;
IP
 |
 |