Currently, there is one user which has below permissions in one azure sql database:
SELECT ON SCHEMA::SYS
VIEW DATABASE STATE
VIEW DATABASE PERFORMANCE STATE
but I cann't find the session status from all users by sys.dm_exec_sessions, dm_exec_connections and dm_exec_requests.
From the MS site, https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-sessions-transact-sql?view=sql-server-ver16,
it says that
SQL Database: Requires
VIEW DATABASE STATE to see all connections to the current database.
VIEW DATABASE STATE can't be granted in the