Forum Discussion
dakramar
Apr 13, 2023Copper Contributor
I need all connection of all users on tables
Hello, I need all sql connections of all users on tables of a database. What options do I have, who has an idea. Thanks
olafhelper
Apr 14, 2023Bronze Contributor
I need all sql connections of all users on tables of a database
Users connect to a SQL Server and they may change the connection context to a specific database (or not), but they never "connect" to a table. They can query data from a table in several way, from the table directly or over a view or using a stored procedure.
So there is not really a way to get the wanted informations.