Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Current users connected to database
This query works fine for me because I have DBA privileges. But it does not
work for users who have limited privileges. Can or should I grant privileges
on
v$session to my users. Or is there any other way to find list of users
currently logged on to the system.
Thanks
sanjay
"R Chin" <rchin_at_panix.com> wrote in message
news:a6ar08$2k4$1_at_reader2.panix.com...
> select username, osuser from v$session where username is not null;
>
>
> Kiefer wrote in message ...
> >Hello everyone!
> >Is there a way to determine which users are currently connected to the
> >database?
> >Thanks.
> >Lesley
> >
> >
>
>
Received on Mon Mar 11 2002 - 10:45:46 CST