Grant permission through an app.

Question

We can grant the permission to other user in sql through some commands but how can we grant those permisson through an app.
We login through app then it automatically logged in in sql, in app list of user display so we can grant them some permission to insert or describe in table.

Answer 1

Do you use phpMyAdmin as MySQL interface? it was what I used before (long time ago). I learned how MySQL manages users and privileges from that tool, and from that tool also I learned which system tables are written/modified to achieve the intent. I don't know which tool you use for MySQL users management, but if it also shows you such information I guess you can make use of it. It basically works by adding, updating or deleting information from some system tables. Though it might have changed since I was using MySQL.

Answer 2

Are you talking about users of your app or users of MySQL? wouldn't it be easier to use dedicated apps for MySQL management for the latter case?

Answer 3

I'm sorry, but I still don't understand clearly whether you want to create your own user management (for your app) or are you using MySQL user management.

Do you know how to create new users and privilege assignment in MySQL? try to search how it works manually first, then once you understand how it works you can proceed doing it programmatically.

If you want to create your own user management (for your app) then there are more things to consider.

Answer 4

When we create an Id in app it will automatically created id in MySql, usually It looks like Mysql is the backend and an app is frontend, if we change in frontend then the change will effect in backend also. Please help me where do I start.

Answer 5

Its like we handle user management system of mysql through an app.
I know to grant the permission of different user in mysql but I want to handle it through an app.