Different rows returned when using same user on different jump server

WisonHii 81

Here is one prd database, which we can only access on 2 PRD jump servers. But when we run the "select * from sys.dm_exec_sessions" using the same user on 2 prd jump servers, it returned the different rowset.

on Jump Server A, it only returns the background sessions+ the sessions issued by the user

on Jump Server B, it can return all the sessions in the database.

BTW, the user has the VIEW DATABASE PERFORMANCE STATE and VIEW DATABASE STATE permission

GeethaThatipatri-MSFT 29,502 Reputation points Microsoft Employee

2023-10-31T13:22:02.06+00:00

@WisonHii https://learn.microsoft.com/en-us/rest/api/cosmos-db/

Looks like this is a duplicate post from here https://learn.microsoft.com/en-us/answers/questions/1409993/different-rows-returned-when-using-same-user-on-di

Regards

Geetha
WisonHii 81 Reputation points

2023-11-03T01:54:27.8833333+00:00

Hi @GeethaThatipatri-MSFT ,

When I create this post, it has some error. I thought failed to create it, so posted another one.

Share via

Different rows returned when using same user on different jump server

Your answer