Different rows returned when using same user on different jump server
WisonHii
81
Reputation points
Here is one production database, so we only need to access it on anyone of 2 jump servers.
But when we use same user on different jump servers to run "select * from sys.dm_exec_sessions", the rows returned is different.
on Jump Server A, it only returns background sessions+the sessions issued by the user
on Jump Server B, it can return all the sessions in this database.
Actually, the user has VIEW DATABASE PERFORMANCE STATE and VIEW DATABASE STATE permission.
My question is: why it has different rows returned on different jump servers?