Yeshiva Net is extremely effective and worth every penny and the minor annoyance in having to request specific sites and waiting 5 minutes to get the access. Once access is granted it stays open (assuming it’s a approved site).
It is perfect for people who don’t need to search the web constantly but have 20/50/80 however many sites that they frequent again and again.
They do allow open internet for finite periods of time (if someone needs it for whatever reason) and it is monitored.
To the best of my knowledge it can not be overridden as it’s not a filter nor a password.