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 ?