使用新建数据库用户加载数据需要的最小权限是什么？
warning:
这篇文章距离上次修改已过1629天，其中的内容可能已经有所变动。
对于随机分布表、复制表、nocopies表的加载需要file权限，加载表的insert权限，gbase.table_distribution的select权限；
对于哈希分布表，除了需要上述权限外，还需要gbase.nodedatamap的select权限。
加载随机分布表、复制表、nocopies表用户权限示例：
gbase> show grants for u1;
+--------------------------------------------------------------------------------------------------+
| Grants for u1@% |
+--------------------------------------------------------------------------------------------------+
| GRANT FILE ON *.* TO 'u1'@'%' IDENTIFIED BY PASSWORD
'*556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5' |
| GRANT INSERT ON "db1"."t1" TO 'u1'@'%' |
| GRANT SELECT ON "gbase"."table_distribution" TO 'u1'@'%' |
+--------------------------------------------------------------------------------------------------+
3 rows in set (Elapsed: 00:00:00.00)
加载哈希分布表用户权限示例：
gbase> show grants for u1;
+--------------------------------------------------------------------------------------------------+
| Grants for u1@% |
+--------------------------------------------------------------------------------------------------+
| GRANT FILE ON *.* TO 'u1'@'%' IDENTIFIED BY PASSWORD
'*556BEF296211C2AF58F53DA3EDDD0A3371B6ECD5' |
| GRANT INSERT ON "db1"."t2" TO 'u1'@'%' |
| GRANT SELECT ON "gbase"."table_distribution" TO 'u1'@'%' |
| GRANT SELECT ON "gbase"."nodedatamap" TO 'u1'@'%' |
+--------------------------------------------------------------------------------------------------+
4 rows in set (Elapsed: 00:00:00.00)