Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How could I extract user name?

Re: How could I extract user name?

From: Screamer <mflopes_at_bigfoot.com>
Date: Tue, 21 Mar 2000 07:27:47 -0000
Message-ID: <8b7fi3$j2$1@duke.telepac.pt> 





select osuser, terminal from v$session


where ......



If anyone can help on the where clause i would appreciate.



Gennady <gennadyb_at_halcosoftware.com> wrote in message
news:38d11e4e$0$848_at_fountain.mindlink.net...


> Hello,


> I have Oracle 8.0.5  DB with application schema  and 2 real Oracle Client


> users


> with DBA privilege. How can I extract real client user name when he


> connected as application schema


> user?


> Thanks,


> Gennady


>


>


>




Received on Tue Mar 21 2000 - 01:27:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US