Hello All,
I have an AD group provided as DBmanager and Loginmanager roles at Azure Server level (meaning master database)
When I execute the below query :
EXECUTE sp_delete_firewall_rule @name = N'<<Name>>'
I get the below error:
Msg 15247, Level 16, State 101, Procedure sp_delete_firewall_rule, Line 1 [Batch Start Line 2]
User does not have permission to perform this action.
So what permission do I need to give to be able to execute that task? Is that even possible ?
Note: I cannot add that group in server AD admin as another user group has that.
I need to somehow reciprocate the access to the new DL