Forum Discussion
Helper IIISQl Database Preview CheckBox
Hello SeattlePowerBI - I do see that SQL Databases (and a few other features) have the 'capacity admins can enable/disable' checked without the ability to uncheck it. I tested and have confirmed that capacity admins can enable this for all users in the respective capacity, even those that are not included in the security groups specified at the tenant level. I have submitted a ticket to get feedback on how this can be controlled.
Support Request ID 2505120040010670
Super UserHi SeattlePowerBI ,
You're correct in observing that the checkbox for "Fabric admins can create" is inherited from the tenant-level setting, which means it cannot be overridden at the workspace or capacity level unless that tenant setting is changed.
Even if you've restricted SQL Database Preview creation to a specific security group, Fabric admins may still retain the ability to create it if the tenant-level setting allows it. This is because tenant settings take precedence over scoped security group restrictions.
To ensure that only members of your specified security group can create SQL Database Previews, you would need to:
- Disable the tenant-level setting that allows Fabric admins to create SQL Database Previews.
- Then, enable it only for the specific security group you’ve defined.
If you don’t have access to tenant-level settings, you may need to coordinate with your global administrator.
Hope this clarifies things!
Helper IIII will try disabling this setting in tenant, unchecking the box, then enabling again with security groups. Unfortuantely, this creates a service disruption for exisiting users in those security groups. MS should fix by allowing checking / unchecking regardless. We missed the notification about this being enabled by default and now would like to remove it but can't without causing an issue for our Fabric user base.