所有表查询权限: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;