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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out current users in Oracle 7.3

Re: How to find out current users in Oracle 7.3

From: Chinna <jchinna_at_enron.com>
Date: 1997/10/06
Message-ID: <01bcd295$d716ffa0$06f7fb9b@eoghou1325.eog.enron.com>#1/1

try V$SESSION_CONNECT_INFO. But you must have dba privileges to access the view. (OR)
try SYS.V$SESSION_CONNECT_INFO with other accounts(doubtful).

let me know if this helped.

Chinna

Wolfgang Hann <W.Hann_at_netway.at> wrote in article <01bccf3a$b376ee60$0201030a_at_ENTWICKLUNG.NETWAY.AT>...
> I have searched in a lot of manuals to find out
> a simple question, but i might be blind - i canĀ“t find it.
>
> How can i find out which users are connected to Oracle?
> I need this to count the users, so the number of all
> connected ones would be enough.
>
> Thanks
>
> Wolfgang Hann
>
>
  Received on Mon Oct 06 1997 - 00:00:00 CDT

Original text of this message

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