v5.1.1 User & Role SQL CREATE USER ‘finley’@‘localhost’IDENTIFIED BY ‘password’ ALTER USER ‘finley’@‘localhost’IDENTIFIED BY ‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; Authorization SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS

follows: User & Role SQL CREATE USER ‘finley’@‘localhost’IDENTIFIED BY ‘password’ ALTER USER ‘finley’@‘localhost’IDENTIFIED BY ‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; Authorization SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS

‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; 授权 SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS FOR ‘jeffrey’@‘localhost’ SHOW GRANTS FOR CURRENT_USER FLUSH PRIVILEGES PostgreSQL PostgreSQL 不支持的 SQL 清单如下： TODO SQLServer SQLServer 不支持的

‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; 授权 SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS FOR ‘jeffrey’@‘localhost’ SHOW GRANTS FOR CURRENT_USER FLUSH PRIVILEGES PostgreSQL PostgreSQL 不支持的 SQL 清单如下： TODO SQLServer SQLServer 不支持的

‘new_password’ DROP USER ‘finley’@‘localhost’; CREATE ROLE ‘app_read’ DROP ROLE ‘app_read’ SHOW CREATE USER finley SET PASSWORD = ‘auth_string’ SET ROLE DEFAULT; 授权 SQL GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ ‘jeffrey’@‘localhost’ GRANT SELECT ON world.* TO ‘role3’; GRANT ‘role1’, ‘role2’TO ‘user1’@‘localhost’ REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ REVOKE ‘role1’, ‘role2’FROM ‘user1’@‘localhost’ REVOKE ALL PRIVILEGES PRIVILEGES, GRANT OPTION FROM user_or_role SHOW GRANTS FOR ‘jeffrey’@‘localhost’ SHOW GRANTS FOR CURRENT_USER FLUSH PRIVILEGES PostgreSQL PostgreSQL 不支持的 SQL 清单如下： TODO 4.1. 数据库兼容 22 Apache ShardingSphere

sharding tables with multiple data nodes, and no binding table rules are configured, t_user and t_user_role are single tables that distributed on different database instances. Federation ex- ecution engine t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; 4.2. Sharding 35 Apache ShardingSphere document 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u 1; SELECT * FROM t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id WHERE u. user_id = 1;

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id 8.1. Sharding 31 Apache ShardingSphere document WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id

tables with multiple data nodes while no binding table rules are configured, and t_user and t_user_role are single tables distributed across different database instances, then the Federation execution t_user u ON o.user_id = u.user_id WHERE o.user_ id = 1; SELECT * FROM t_order o LEFT JOIN t_user_role r ON o.user_id = r.user_id WHERE o. user_id = 1; SELECT * FROM t_order_item i LEFT JOIN t_user u t_order_item i RIGHT JOIN t_user_role r ON i.user_id = r.user_id 8.1. Sharding 31 Apache ShardingSphere document WHERE i.user_id = 1; SELECT * FROM t_user u RIGHT JOIN t_user_role r ON u.user_id = r.user_id