MySQL赋予用户只读权限，以及函数执行权限

最新推荐文章于 2025-01-15 11:52:31 发布

原创最新推荐文章于 2025-01-15 11:52:31 发布 · 913 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库

记录下MySQL数据库创建用户，并赋予该用户读取某些表的权限，以及执行函数的权限

CREATE USER 'new_user'@'%' IDENTIFIED BY '1qaz@WSX3edc';
GRANT SELECT ON ourea.t_info_track TO 'new_user'@'%';
GRANT SELECT ON ourea.t_info_track_change TO 'new_user'@'%';
GRANT SELECT ON ourea.t_cfg_event_type TO 'new_user'@'%';
GRANT SELECT ON ourea.t_info_requirement TO 'new_user'@'%';
GRANT SELECT ON ourea.t_cfg_business_version TO 'new_user'@'%';
GRANT SELECT ON ourea.t_info_position TO 'new_user'@'%';
GRANT SELECT ON ourea.t_info_position_change TO 'new_user'@'%';
GRANT SELECT ON ourea.t_cfg_business TO 'new_user'@'%';
GRANT SELECT ON ourea.t_cfg_business_attached TO 'new_user'@'%';

GRANT EXECUTE ON FUNCTION ourea.replaceI18nKey TO 'new_user'@'%';
GRANT EXECUTE ON FUNCTION ourea.replaceI18nKeyByLocale TO 'new_user'@'%';

FLUSH PRIVILEGES;