mysql、mssql数据库有限访问命令行设置

需求：创建用户user0477密码为7B9MccbUo8MTZ，仅能查询数据库dter的lex表

mysql

CREATE USER 'user0477'@'%' IDENTIFIED BY '7B9MccbUo8MTZ';
GRANT SELECT ON dter.lex TO 'user0477'@'%';
FLUSH PRIVILEGES;

mssql

CREATE LOGIN user0477 WITH PASSWORD = '7B9MccbUo8MTZ';
USE dter;
CREATE USER user0477 FOR LOGIN user0477;
GRANT SELECT ON lex TO user0477;

至于GRANT数据库权限，可参考官网手册