You can determine sessions using Oracle's data dictionary tables. I think
the one you would want to look at is V$SESSION. It contains current
session information. You would need special privileges to the view.
You may need to work with someone with DBA privileges in Oracle to set this up.
HTH.
Janet.
At 10:23 AM 5/28/2004 -0400, you wrote:
>Has anyone done this before? I have a task that I must check to see if
>the user already has an Oracle session active when they log on. If they
>do, do not allow the logon. If they don't, let them continue. The Oracle
>session lasts for 15 minutes of inactivity. When the user logs out of the
>application, I need to log them out of Oracle as well.
>
>Thanks in advance
>
>Brian Yager
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
