I have users that access the database via windows groups.

I want to kill their sessions and avoid them to be able to log in again during the run of some DTSx (running under a different account).

The windows user the DTSx is running under don't need/have administrative rights.

This is why "alter database ... set restricted_users" is not an option.

Is there an way to achieve this without giving db_owner rights or similar to the DTSx users ?