gbase8a远程导出数据需要开通的权限

数据库用户执行 rmt 远程导出需要具有 file 权限和导出表的 select 权限。

gbase> show grants for u1;

+----------------------------------------+

| Grants for u1@%

|

+----------------------------------------+

| GRANT FILE ON *.* TO 'u1'@'%'

|

| GRANT SELECT ON "guo"."t1" TO 'u1'@'%' |

+----------------------------------------+

2 rows in set (Elapsed: 00:00:00.00)

gbase> rmt:select * from t1 into outfile '/home/gbase/t1.txt';

Query OK, 3 rows affected (Elapsed: 00:00:00.01)