Forum Discussion

dakramar's avatar
dakramar
Copper Contributor
Apr 13, 2023

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

 

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 14, 2023
    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.

Resources