MySQL Plugin - Permissions Are Failing

Hi All,

I’m attempting to store most of my data in mysql (it’s a lot of related data with lots of many-to-many relationships, coming up on 30 tables) and I’m having a problem with permissions.

Right now, if I go to my page say xyz.com/contacts?contact_id=2, I check a MySQL Database Connector Query to see if the current user has access to that contact’s information using the “When Page is Loaded” workflow.

The problem is that the page is visible (with data and information) for a second or so before redirecting the user elsewhere using this method. Is this a limit of Bubble I’m running into? Is there no way to do really good permissions without using bubble’s built-in DB? I really want to do this check BEFORE loading the page I suppose.