How to check Azure SQL firewall rues with TSQL
In the master database of the Azure SQL server. select * from sys.firewall_rules
How to check user permissions on DB objects
How to check SQL server DB role membership
This is the TSQL to check the membership of a db role in MS SQL Server