Re: How to limt user connections

Logon trigger by itself will not work if the user connects before the deadline.
You also need to run a script to kill all sessions of the users after the cutoff time.

Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "David Sharples" <davidsharples_at_gmail.com> To: <oracle-l_at_freelists.org>
Sent: Sunday, February 06, 2005 5:00 PM
Subject: Re: How to limt user connections

> logon trigger based on username
>
>
> On Sun, 6 Feb 2005 15:55:39 +0100, Sonja =C5=A0ehovi=C4=87
<sonja.sehovic_at_p=
> bz.hr>=20
> > Oracle 9.2.4 in AIX 5.2.
> > I would like to limit time frame when some of my users can connect to
=3D
> > one of the databases.=3D20
> > That is, they can do whathever they want/need between 6 p.m. and 7. =3D
> > a.m...:-)
> > Is that possible to do with profiles? Or is there any other (better) =3D
> > method?
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l