Django 3 + MySQL + User privilages in DB server

[Wojciech Jędrzejczyk]

I am going to create in Django new fornt-end (HTML + JS + CSS) to old application based on big MySQL database (lots of tables, views, stored procedures, logs, triggers and so on). I need to force Django to respect database privilage for each user. I know I can give in django some rights e.g. to the model or view but when I have table "customers" i want to give access to the user to few, selected customers from this table, not to all records. In another words: django has connection to MySQL by one django user and all users in django make operations on database tgough this django user. How can I force django to check user privilages in MySQL server ?

I have all the logic in database in stored procedures. I can add input parameter to each procedure {e.g. IN v_user char(50)} and django will call these procedures with this parameter. This will work very well but this solution does not provide security. I have invested a lot of time in learning django and I really like this framework. I have already prepared many html+css templates, I have bought theme from bootstrap. I am in the middle of my work but I cant continue until I find solution which will ensure that the user will have rights from the database.

Regards

Wojtek