Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Auto Logoff / Limit User Connections ????
Check the create profile command in your database docs (or use
http://technet.oracle.com) This will allow you to set an idle and limit the
number of sessions.
Please not however in the former case the client process is *not* killed, it
is disconnected only.
Hth,
Sybrand Bakker, Oracle DBA
"Chuck Rizzio" <carizzio_at_snet.net> wrote in message
news:fMBi5.1664$xH6.424824_at_typhoon.snet.net...
> I have two questions...
>
> We are running Oracle Applications version 10.7 Smart Client. Datavase
> version - 7.3.4.5.
>
> First, we have users who constantly leave at the end of the day without
> loggin out of Oracle Apps. Frequently, they leave records on their
screens
> causing locks which prevent other processes from accessing the data. Is
> there any way to institute automatic logoff where we can set some time
limit
> (i.e. 30 minutes) of inactivity to terminate the connection?
>
> Second, we have users that insist on running more than once "instance" of
> the client. They claim that need to in order to do their jobs. They need
> access to data in different areas (i.e. customer data and purchasing data)
> and say that having to use one session and go from one are to another
takes
> too long. Is there a way to limit a user to only one connection frome
> either the same machine or for the user logon?
>
> Please reply to my email address (carizzio_at_hotmail.com) as well as the
> newsgroup as I don't get here very often. Thanks.
>
> Chuck
>
>
Received on Fri Aug 04 2000 - 00:00:00 CDT