E-Notebook Enterprise: we want E-Notebook users to be automatically locked after a certain amount of time

For security and stability reasons, we want E-Notebook users to be automatically locked after a certain amount of time (15 minutes).

Connect to database as ELN schema owner, and run as script following code:

declare

TZB number;
sKey NUMBER(10,0);
vkey number(10,0);
revision varchar2(3000);
rindex number;

begin

select -1*to_number(substr(tz_offset(sessiontimezone),1,1)||'1')*
(60*to_number(substr(tz_offset(sessiontimezone),2,2))+to_number(substr(tz_offset(sessiontimezone),5,2))) into tzb from dual;

start_session(sKey, 1, TZB);
-- dbms_application_info.set_client_info(skey);
for rec in (select home_collection_key from eln_people where primary_key = 1 ) loop
create_version(vkey, rec.home_collection_key, 'changed session_timeout parameter from eln_parameters table', 0);
end loop;

Update eln_parameters set data = '15' where name = 'session_timeout';

end_session(skey);

commit;

end;
/

Note: If you still need assistance, contact support