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 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

Answer: C

Explanation:https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/

ids_sqs_0125.htm

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments