Re: Checking for User Logged In

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Thu, 24 Sep 1998 16:40:08 GMT
Message-ID: <360A75E7.F6119518@bechtel.com>

Part of that depends on what you consider as "logged in". One table you can query is the V$SESSION table. You can check this table for the username and it will show if there is a connection from that user. I am assuming you are talking about the database user. There is also a column in that table that will tell you the OS User name, in case you have multiple people logging into the database using the same database user id. The background processes also show up in this table.

Dave

Simon Gellion wrote:

> Is there any way of checking, using SQL, whether a user is still 'logged in'
> to an Oracle database?
>
> Thanks
>
> Simon Gellion
Received on Thu Sep 24 1998 - 11:40:08 CDT