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

bdimple_at_myway.com (B.Dimple) wrote in message news:<eb271e19.0401051442.a2104b3_at_posting.google.com>...
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@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
>
> Hi Ana,
>
> Thanks again.
>
> B.Dimple

Dimple,
Looks like you do not have SELECT privileges on the V$session table. Ask your DBA to give permissions. Received on Tue Jan 06 2004 - 05:40:15 CET