I would like to ask you some basic questions about BBS moderator Authorization. the registered user table (mysql database) of BBS forum contains each user name and password; when authorizing a user as the moderator, does & nbsp; need to be directed to mysql. user table (this table is not a registered user table) to save the user name and password? ------ Solution -------- questions about BBS moderator authorization
I would like to ask you a basic question. The BBS Forum's registered user table (mysql database) contains each user name and password. when authorizing a user as the moderator, do you need to contact mysql. user table (this table is not a registered user table) to save the user name and password?
------ Solution --------------------
Master = 1 or 2 or 3 or 4...
This depends on how your membership management system is designed. for example, the above 1 can be Administrator 2 can be vice administrator...
If you still need to extend other permission restrictions, you can add detailed permission functions to a separate table.
------ Solution --------------------
Reference:
By default, a root user is installed in mysql, which is saved in the mysql. user table. if a new user is created, it is saved in the mysql. user table.
There is a registered user table in BBS. if you grant permissions to a user in the registered user table, do you need to create related information for this user from the mysql. user table? For example, (grant delete, update on a database table to user name @... identifie ......
I didn't pay attention to the fact that you asked mysql users...
No
------ Solution --------------------
You can design your own table (isadmin field), where permissions are required, and the program is controlled.
------ Solution --------------------
No!
Mysql. user is set for the user who saves the database connection
