IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 27

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?

Answer options

• A. Jeff's SELECT privilege will be revoked
• B. Jeff's SELECT privilege will be retained
• 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

Correct answer: A

Explanation

The correct answer is A because when Eddie revokes the SELECT privilege from Mike, it cascades down, resulting in Jeff losing his SELECT privilege since it was granted through Mike. Options B, C, and D are incorrect as they suggest that Jeff's privilege would remain unaffected, which contradicts the rules of privilege inheritance in this context.