Re: How can I check the Users who are online ?

You have to be login as DBA (system or sys) to query V$session view.

Faheem

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396_at_fed1read03>...
> B.Dimple wrote:
> > "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860_at_fed1read03>...
> >
> >>B.Dimple wrote:
> >>
> >>>Hi Oracle Experts,
> >>>
> >>>How can I check the Users who are online ?
> >>>
> >>>Is there a table name which contains a list of DB users (e.g in
> >>>SQLServer the table is sysusers) ?
> >>>
> >>>B.Dimple
> >>>Junior DBA
> >>
> >>select username, osuser from v$sessions;
> >
> >
> > Thanks for the quick response.
> >
> > Unfortunately, when I try your suggestion, I get this error message :-
> > "ORA-00942: table or view does not exist"
> >
> > B.Dimple
>
> select username, osuser from sys.v$session
Received on Mon Jan 05 2004 - 22:01:19 CET