We need to abort specific user sessions every night at 23:00 and stop the user to connect to the DB. Then allow the user to connect to the DB next day at 8:00.
I am new in Oracle. I only know I can kill user session by
alter system kill session 'SID,SERIAL#,@INST_ID' immediate;
But the problem is, KILL SESSION sometimes only mark a session as terminated and roll back ongoing transactions. It does not actually abort the transactions.
Is it possible to KILL SESSION something like abort all their transactions (we allow data loss for this user) ? And is there any way we can restrict the user to connect to DB?
Thank you very much