-- uc为schema pay_rd为账号 t_test为表名
-- 增加读写权限
grant select on uc.t_test to pay_rd;
grant insert on uc.t_test to pay_rd;
grant update on uc.t_test to pay_rd;
grant delete on uc.t_test to pay_rd;
grant truncate on uc.t_test to pay_rd;
-- 同时加权限
grant select,update,insert,delete,truncate on uc.t_test to pay_rd;
-- 加schema权限
grant USAGE on SCHEMA uc to pay_rd;