Re: Checking for User Logged In

One way is to use:

Select username,status from v$session where username is not null;

The 'username is not null' eliminates the background processes - Look at the description for v$session - it has lots of info...

"Simon Gellion" <scg_at_appstation.com> wrote:

>
>Is there any way of checking, using SQL, whether a user is still 'logged in'
>to an Oracle database?
>
>
>Thanks
>
>Simon Gellion
>
>

To reply please remove the 'nospam' part of the address Received on Thu Sep 24 1998 - 14:06:56 CDT