You're looking at creating some custom code, I'd say. There's nothing in the base Oracle database features that can help with time of day login restrictions. If you can create an automated process that locks and unlocks the account at the appropriate times of day, just add something like the PL/SQL code below to the "lock" part of the procedure to identify and remove any sessions they currently have connected (presuming that the application uses "real" database user accounts -- I'm not familiar enough with Banner to know):
FOR i IN (SELECT username,logon_time,sid,serial# FROM v$session WHERE username IN ('STUDENTWORKER1','STUDENTWORKER2') ) LOOP DBMS_OUTPUT.PUT_LINE('killing off session '||i.sid||','||i.serial#|| ' for '||i.username); execute immediate 'alter system kill session '''||i.sid||','||i.serial#||''''; END LOOP;
Dig Deeper on Oracle database security
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.