//查看权限
grant select on user1.SMOSPREGISTER to user2;
grant select on user1.SmOspImgRegister to user2;
grant select on user1.SmDataSourceInfo to user2;
grant select on user1.SMFieldInfo to user2;
grant select on user1.数据集表名 to user2; //对于所有的数据表
grant select on user1.数据集表名_RDT to user2; //对于栅格数据
//增加对象权限
grant update on user1.SMOSPREGISTER to user2;
grant insert on user1.数据集表名 to user2;
//编辑对象权限
grant update on user1.SMOSPREGISTER to user2;
grant update on user1.数据集表名 to user2;
//删除对象权限
grant update on user1.SMOSPREGISTER to user2;
grant delete on user1.数据集表名 to user2;
//修改表结构权限
grant select on user1.sm_seq_fieldinfo to user2;
grant insert on user1.SMfieldinfo to user2;
grant delete on user1.SMfieldinfo to user2;
grant alter on user1.数据集表名 to user2;