13.03.2017, 12:32
(
Последний раз редактировалось Unte99; 14.03.2017 в 07:46.
)
Is it possible to make from inside the mysql database to limit a certain users functions, so the user can only add or update a columns value to indicated max?
EDIT: I made an alternative to what I was trying to do. In case someone wants to make a user in mysql database for a specific person, group or whatever it is you are making the user for, you can restrict the columns for the specific user and then don't use those rows in any queries. The unused columns will just be automatically left to 0, empty string, false and etc. Or you can use the Default function in the structure view of the column and set a default value for whenever a query is sent without a certain column and a value for it the default value for the column will be used instead. This will ensure that nobody is messing with your database.
EDIT: I made an alternative to what I was trying to do. In case someone wants to make a user in mysql database for a specific person, group or whatever it is you are making the user for, you can restrict the columns for the specific user and then don't use those rows in any queries. The unused columns will just be automatically left to 0, empty string, false and etc. Or you can use the Default function in the structure view of the column and set a default value for whenever a query is sent without a certain column and a value for it the default value for the column will be used instead. This will ensure that nobody is messing with your database.