How to kill old report user connections...

ClayGoss

Member
We have OE10.1A running on WS2K3R2. Against it, we run various reporting tools like Crystal using a generic, read-only user. After some days, there are a bunch of connections left open under this user as folks have crashed out or the like. Someone must go in once a week and manually disconnect these user connections or all the licenses get used up.

I would like a script, that I can schedule that removes any connection under this generic user which is older than today. Is this possible?

Thank you!
 
Top