Re: How to limt user connections

  • From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 14 Feb 2005 15:44:59 +0200

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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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?
> --
> //www.freelists.org/webpage/oracle-l

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

Other related posts: