In one of my codebases, I have a table with sensitive user information. Some users might want to alter this user information using their usual username and password -- no external authenticator needed. Some users might only want to alter this user information using a Google authenticator app. Some users might only want to alter this information by means of text message. Still others might want to use a private key signature to alter this sensitive information. And lastly, I have a custom security challenge I'd like to give users the option to provide.
Is there any way that I can easily have a mysql trigger a sort of security pop-up with the required challenge every time certain users want to modify this information? It is the part about having a mysql trigger communicate back to laravel that is giving me trouble. I know that I could go through each function that modifies this table and input the pop-up script manually, but since there are numerous developers working on this codebase, it might be safer to have this as the lowest level possible.
I was just wondering if there was a way for a mysql trigger to "pause" and wait for some type of verification before executing the command, without destroying everything else about the database.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire