You could access v$process table to get distinct list of username.
v$process contains username char(13)
terminal char(8)
program char(64)
and lot of other information.
------------------------------------------------------------------------------
In article <30630_at_nntp_server.ems.cdc.com> mgrimley_at_ems.cdc.com writes:
>
>I am looking for a way for a Pro*C program to retrieve a list of all
>the users who are currently using the database. I have been reading
>through the data dictionary views but I do not see any views that
>identify the active users.
>
>Mary Grimley email: mgrimley_at_ems.cdc.com
>Empros Systems International phone: (612) 553-4763
>2300 Berkshire Lane North Facility Code: PLY008
>Plymouth, MN 55441 USA
>_____________________________________________________________________________
E-mail : kortikar_at_mipos2.intel.com | A billion here, a billion there ...
Phone(W): 408 765 5515 | pretty soon it adds upto real money.
-------------------------------------------------------------------------------
Received on Tue Nov 24 1992 - 17:28:00 CST
