SQL PI allows to see detailed information related to objects in a database. For example: Tables, Objects, Sessions, etc.
How to check which users are accessing a specific table / view / object of a database by using the object name?
WORKAROUND:
SQL PI allows to check the information in different perspectives and in different levels.
For example if you want to check the sessions of a single user, the information could be accessed as follows:
Databases | | Sessions | | Users
Databases | | Users | | Sessions
Different combinations can be used when checking the information.
In order to check which user access a specific object in a database, you can check the information as follow:
Databases | | Objects I/O will show you a summary of all the objects being accessed by the SQL Statements listed on Databases | | SQL Statements.
In Databases | | Objects I/O, the search box allows you to filter the objects.
Once the object appears listed, the button "Drill to Object I/O" will move the cursor to the object. At this point, the information of the Users will be shown for the specific object.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center