Auto creation of temporary TNEW log in none exists

Hi all,

We are looking for a way of creating temporary TNEW log ins when none exists on a constituent record. I've seen a few old forum posts discussing jobs that on a schedule to do just this but can't find whether anyone has some SQL they can share that does this?

Any help would be very much appreciated!

Many thanks,

Hannah