Model users mass management

[Typia]

Hi guys,
I have a model with security enabled and users added over time (more than 100 ..)
I would like to clean up and remove every user in the model but local admin one.
Currently I can't select more than 1 user a the time and list is refreshed every time I click on delete.

Any way to mass modify users ?

Many thanks

[qwerty]

You could run a repository.execute("DELETE FROM t_secuser WHERE userlogin <> 'admin'")

That's just out of my head without testing. So make a backup and try out.

q.

[Geert Bellekens]

You could run a repository.execute("DELETE FROM t_secuser WHERE userlogin <> 'admin'")

That's just out of my head without testing. So make a backup and try out.

q.

I'm not sure if that is the best idea. You risk creating orphaned records at table such as t_secusergroup, t_secuserpermission, t_seclocks and maybe others.

It will be faster and safer to simply delete the 100 users using the GUI. That isn't going to take more than half an hour is it?

Geert

[Typia]

You could run a repository.execute("DELETE FROM t_secuser WHERE userlogin <> 'admin'")

That's just out of my head without testing. So make a backup and try out.

q.

I'm not sure if that is the best idea. You risk creating orphaned records at table such as t_secusergroup, t_secuserpermission, t_seclocks and maybe others.

It will be faster and safer to simply delete the 100 users using the GUI. That isn't going to take more than half an hour is it?

Geert

You're right.
atfer recount I had almost 500 users (imported from AD ..) I deleted manually