Checking for User Logged In 
Author Message
 Checking for User Logged In

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

Thanks

Simon Gellion



Mon, 12 Mar 2001 03:00:00 GMT
 Checking for User Logged In

Hi !
this is my first reply, but try v$session:

select username from v$session;

M.

Quote:

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

>Thanks

>Simon Gellion



Mon, 12 Mar 2001 03:00:00 GMT
 Checking for User Logged In
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

Quote:

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

> Thanks

> Simon Gellion



Mon, 12 Mar 2001 03:00:00 GMT
 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...

Quote:

>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


Mon, 12 Mar 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Checking for logged users

2. Check user log on

3. check rights for executing stored procedure not for logged user

4. Checking logged users within progress session

5. How to check the corruption in online redo logs and archived logs

6. User check if an record from a table is locked by other user ar run time

7. Log Shipping - logging users out

8. User Name of Logged In User through ODBC Connection

9. Calling Stored Proc as another user other than the logged in user

10. Connecting using NT user info ( other than the logged in user )

11. error: Cannot set user when user logs in

12. Integrity Check and Txn Log Backup both Fail


 
Powered by phpBB® Forum Software