Re: User is not allowed to work in a period of time
From: Maximus <qweqwe_at_qwqwewq.com>
Date: Mon, 11 Aug 2003 18:41:14 GMT
Message-ID: <erRZa.701141$3C2.16454778_at_news3.calgary.shaw.ca>
Date: Mon, 11 Aug 2003 18:41:14 GMT
Message-ID: <erRZa.701141$3C2.16454778_at_news3.calgary.shaw.ca>
"LKBrwn_DBA" <member30625_at_dbforums.com> wrote in message
news:3225650.1060623547_at_dbforums.com...
>
> You could have a job that 'locks/unlocks' the users at cretain
> times issuing:
>
> ALTER USER TheUser ACCOUNT LOCK;
> (or UNLOCK);
That will prevent subsequent logins, however if the user already has a session established then locking the account will not disable access. Received on Mon Aug 11 2003 - 20:41:14 CEST