dynamic privileges for web applications

[mohamed sdiri]

Hello,
I want to design a dynamic privileges system to be applied in relation to some bundles (modules) of my monolithic web application in PHP. My goal is to ensure security by applying custom privileges for each user based on their roles at the database level, not just relying on the application logic. This approach aims to prevent any unwanted behavior in the web application, such as arbitrary execution due to undiscovered vulnerabilities.

During my research, I discovered that one way to achieve this is by creating multiple database users. However, it is strongly advised against switching between multiple database users, and there are no arguments in favor of it. In my application, I have numerous user profiles, each with different access permissions, similar to what we find in cloud solution providers.

Is it possible to implement this in MySQL?