SQLTeam.com | Weblogs | Forums

How to terminating all users who uses a particular database's table

Good morning,
I am new. I would like to seek your helps and expertise on how to terminating all users who uses a database table. I have a AdventureWord database, and I have a table named Reporting in this database. I have users who use the reporting database. My question are

  • I would like to know all of the user name who use the Reporting table of the Adventurework database.
  • I would like to have a query to terminate the jobs of all of the above users who use the Reporting table of the Adventurework database.

I would like to seek your helps if you could help me with the two above items.

Thanks,
Dumi

Welcome,

How are they interacting with this reporting database? Through a report portal or directly?