Database access control?

Question

MySQL

Hello. There is a database in which data is added/changed/deleted/search is performed/reports are displayed in excel. With QtCreator.
This application will be used by several people. How it is possible to organize differentiated access? The first person who logged into the app can replay any action. Other users can only search and report?
Using transactions?
QSqlDatabase::database().transaction()
or locks in mySQL?
SET LOCK
Or is there some better way?

Answer 1

Using roles