Killing DB logins after a period of time

[kiszka6911]

I am looking for a way to kill or exit users database login's after a period of time. We are using progress on NTSP6a version 9.1d. I have written an "at" command that shuts down the DB every night at midnight and then restarts it. This clears old users off but we only have 20 licenses and are constantly throughout the day running out. We would want to shut them down after some period of time.

Anthony J. Kiszka
IT Manager
Orbitform Inc.
1600 Executive Drive
Jackson, MI 49203
517-787-9447 ext 219
517-787-6609 FAX
"World Leaders in forming, fastening and riveting System"
akiszka@orbitform.com

 

[parul]

proshut can be used to evict the users.
proshut <data base path> -C disconnect <user id>.

Database path can be found from _fileList Table.

Information about users like username, userid can be found from _connect table.

_Connect-Name
_Connect-Usr
_Connect-Time

Then according to your need users can be disconnected from the database.

I once wrote a utility of the same kind, if you need more help in terms of code let me know.

Regards,
Parul.