|
-
 Which the data that I obtain of view DUAL?
I am in a company who 50% of the employees if connect by
application server, being thus view v$session does not show who
are loggged.
View dual brings this information, does not remember as to make
to remove this information.
Who can help me?
Tanks.
Last edited by hhbrazil; 05-23-2003 at 09:08 AM.
-
-
More or but this, I know that the dual shows of terminal/machine
the user has connected... I need of this information
-
Use sys_context function.
example...
select sys_context('USERENV','OS_USER') from dual;
select sys_context('USERENV','IP_ADDRESS') from dual;
select sys_context('USERENV','TERMINAL') from dual;
HTH
Amar
"There is a difference between knowing the path and walking the path."
 
-
OMG so much info in a single row single column table?? 
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Obviously NOT normalised!
-
Oh great!
tank you a lot... Mr adewri
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
|
Reply With Quote
