Access to pages by roles equivalent to Mysql DB connections?

Question

MySQL

A small internal project / tool with a client part on Vue and a server part on Node with a Mysql database (Sequelize ORM). There is only one table in the database with 2 users (one user with view-only rights, the other with everything). How correctly (as far as possible) to organize connections to the database so that the user's access to (let's say, to the edit page) is exactly by login and password from a specific database user. It's not clear how to identify database connections from the client...? When to make connections - immediately or as needed?

Answer 1

What for to you to identify connections with a DB? You are working with the application. We went under the user, checked the levels of his access in the application logic and let him or not let him into the area where he requested access.