I have a VPS with Root access.
I believe there IS a way to grant User Privileges in MySQL, and that is what I have been asking about. (I know that my PHP properly handles Logging In/Out and prohibiting Users unless they are accessing their own Account, but I believe there is an additional layer of security here on the backend.)Quote:
I don't think there's a way to set privileges per user in MySQL.
This thread has morphed and I'm a bit lost.Quote:
The common way is to have a "privileges" table eg.
Userr_Id ... Role
123 .......... 1
234 .......... 1
432 .......... 2
Then you do a SELECT and if the user has an adequate role level you continue else no go.
Guess this part would be better suited in the MySQL Forum. Oh well.