Re: User is not allowed to work in a period of time
From: Maximus <qweqwe_at_qwqwewq.com>
Date: Sat, 09 Aug 2003 21:49:41 GMT
Message-ID: <V%dZa.714952$Vi5.16346040_at_news1.calgary.shaw.ca>
Date: Sat, 09 Aug 2003 21:49:41 GMT
Message-ID: <V%dZa.714952$Vi5.16346040_at_news1.calgary.shaw.ca>
You can kick a user off via "alter system kill session 'sid, serial'
Just use v$session to lookup the sid and serial of the user
"Jorge Pinto" <jorgep_at_sympatico.ca> wrote in message
news:gSaZa.5856$ox5.649336_at_news20.bellglobal.com...
> Hi Folks,
>
> I have a schema trigger in user A that checks if this user in the table
> "FOO" is allowed to connect at a specific time. The problem is I don't
want
> the user to be logged on if he is not supposed to be. I tried to raise an
> error, but the user is still connected !!! Any good thoughts to help me
with
> that ??
>
> Thanks in advance.
>
> Jorge
>
>
Received on Sat Aug 09 2003 - 23:49:41 CEST