所有表查询权限:GRANT SELECT ANY TABLE TO USER_A WITH ADMIN OPTION;
单个表查询权限:GRANT select ON t_pub_instinfo TO USER_A WITH GRANT OPTION;
收回表查询权限:revoke select ANY TABLE from USER_A;
所有表查询权限:GRANT SELECT ANY TABLE TO USER_A WITH ADMIN OPTION;
单个表查询权限:GRANT select ON t_pub_instinfo TO USER_A WITH GRANT OPTION;
收回表查询权限:revoke select ANY TABLE from USER_A;
转载于:https://my.oschina.net/javawdw/blog/700300