Sample Header Ad - 728x90

Permissions for setting a baseline for SQL vulnerability assessment rule

1 vote
0 answers
231 views
I'm getting a SQL vulnerability error discovered by Microsoft Defender for Cloud. The error points to the following Vulnerability Assessment rule . But when I try to set a baseline (recommended by this rule), I get the following error: >The client 'tom.doe@mydomain.com' with object id 'eXXXXXX-...' does not have authorization to perform action 'Microsoft.Sql/managedInstances/databases/vulnerabilityAssessments/rules/baselines/write' over scope '/subscriptions/subscriptionid/resourceGroups/myResourceGroup/providers/Microsoft.Sql/managedInstances/mySQLManagedInstance **Question**: What permissions are required to set the baseline here? | Rule ID | Rule Title | Severity | Rule Description | |---------------------|------------------|------------|--------------------| | VA1281 | All memberships for user-defined roles should be intended| Medium | User-defined roles are security principals defined by the user to group principals to easily manage permissions. Monitoring these roles is important to avoid having excessive permissions. Create a baseline that defines expected membership for each user-defined role. This rule checks whether all memberships for user-defined roles are as defined in the baseline. |
Asked by nam (515 rep)
Jan 31, 2024, 04:07 AM