建立角色用户

1.建立新角色，并授予dd库的查询权限

CREATE ROLE role_name;

GRANT SELECT ON DATABASE dd TO role_name;

2.建立新用户，并使用角色

CREATE USER username IDENTIFIED BY 'password';

GRANT role_name TO username;

GRANT GRANT_PRIV,SELECT_PRIV,LOAD_PRIV,ALTER_PRIV,CREATE_PRIV,DROP_PRIV,USAGE_PRIV ON *.* TO bigdata (2.x)

GRANT ALL ON ALL DATABASES TO 'bigdata'@'%' (3.3)

GRANT DELETE, DROP, INSERT, SELECT, ALTER, EXPORT, UPDATE ON ALL TABLES IN ALL DATABASES TO USER 'bigdata'@'%'

GRANT CREATE TABLE, DROP, ALTER, CREATE VIEW, CREATE FUNCTION, CREATE MATERIALIZED VIEW, CREATE PIPE ON ALL DATABASES TO USER 'bigdata'@'%'