#Laravel multi-database setup with shared users across 3 environments

4 messages · Page 1 of 1 (latest)

buoyant flower
#

Yeah, don't use multiple user tables and just use RBAC instead?

bitter meadow
#

Thanks, RBAC would definitely make sense in general — but in this case I can’t change the existing DB structure. I need to work with it as-is and layer logic on top. I should’ve mentioned that in the original post 😅

willow gale
#

MySQL? What about creating a MySQL view_global_users aggregating data from Admin, Worker and User tables and login againts this global_users?

bitter meadow
#

That’s actually a nice idea and would definitely simplify things if everything lived in the same database. In my case though, the data is split across multiple databases so I can't really use a single view to unify all the user tables.