I think it works for location, camera, video permission.
Not for bluetooth, Wi-fi, NFC, mobile data or airplane mode. These are global settings.
You can't change mobile data in an even unlocked secondary profile in the pulldown menu anyway, you would need a data-usage settings widget to turn it off or on. Same with hotspot.
Tethering however can only be active in the owner profile, and you need to stay on owner for it to stay that way.
And yes, you can have different tiles setting for each user.