User is not allowed to work in a period of time

[Jorge Pinto]

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

[Maximus]

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" <jo****@sympatico.ca> wrote in message
news:gS*******************@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

[LKBrwn_DBA]

You could have a job that 'locks/unlocks' the users at cretain
times issuing:

ALTER USER TheUser ACCOUNT LOCK;
(or UNLOCK);

:cool:

--
Posted via http://dbforums.com

[Maximus]

"LKBrwn_DBA" <me*********@dbforums.com> wrote in message
news:32****************@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.

[LKBrwn_DBA]

Well, if user already has a session then also do the
"alter system kill session 'sid, serial';" thing!!!

--
Posted via http://dbforums.com