根据SQL标准,针对用户Tom拥有对表student和course中的查询权限,并允许他将此权限授予他人,现要将收回Tom的权限,下面哪条语句适用?
A、revoke select on student, course to Tom with grant option
B、revoke select on student to Tom with grant option
revoke select on course to Tom with grant option
C、revoke select on student,course from Tom cascade
D、revoke select on student from Tom cascade
revoke select on course from Tom cascade