What will happen to Jeff’s SELECT privilege?

Consider the following sequence of events:

– Eddie grants SELECT WITH GRANT OPTION privilege to Mike.

– Mike grants SELECT privilege to Jeff.

– Eddie revokes SELECT privilege from Mike.

What will happen to Jeff’s SELECT privilege?
A . Jeff’s SELECT privilege will be revoked
B . Jeff’s SELECT privilege will be revoked
C . Jeff’s SELECT privilege will be retained only if he has ACCESSCTRL authority
D . Jeff’s SELECT privilege will be retained only if Eddie has ACCESSCTRL authority

View Answer

Answer: A