Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out current users in Oracle 7.3
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
![]() |
![]() |