Exam4Training

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

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

ids_sqs_0125.htm

Latest C2090-616 Dumps Valid Version with 63 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version