MySQL 用户权限管理示例：创建用户并分配权限

以下是一个示例代码，展示了如何创建用户并分配合适的权限：

-- 创建数据库维护人员用户
CREATE USER 'maintenance_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON EDUC.* TO 'maintenance_user'@'localhost';

-- 创建信息录入人员用户
CREATE USER 'data_entry_user1'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'data_entry_user2'@'localhost' IDENTIFIED BY 'password';
GRANT INSERT, DELETE, UPDATE ON EDUC.* TO 'data_entry_user1'@'localhost';
GRANT INSERT, DELETE, UPDATE ON EDUC.* TO 'data_entry_user2'@'localhost';

-- 创建成绩管理人员用户
CREATE USER 'grade_management_user1'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'grade_management_user2'@'localhost' IDENTIFIED BY 'password';
GRANT INSERT, DELETE, UPDATE ON EDUC.course TO 'grade_management_user1'@'localhost';
GRANT INSERT, DELETE, UPDATE ON EDUC.course TO 'grade_management_user2'@'localhost';
GRANT SELECT ON EDUC.* TO 'grade_management_user1'@'localhost';
GRANT SELECT ON EDUC.* TO 'grade_management_user2'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

请注意，以上代码仅作为示例，您需要根据实际情况进行适当的修改，包括替换用户名、密码和数据库名称。此外，建议在实际应用中使用更复杂的密码和采取其他安全措施来保护数据库的访问。