网友您好, 请在下方输入框内输入要搜索的题目:
TheuserHRownstheEMPtable.TheuserHRgrantsprivilegestotheuserSCOTTbyusingthiscommand:SQL>GRANTSELECT,INSERT,UPDATEONempTOscottWITHGRANTOPTION;TheuserSCOTTexecutesthiscommandtograntprivilegestotheuserJIM:SQL>GRANTSELECT,INSERT,UPDATEONhr.empTOjim;Now,theuserHRdecidestorevokeprivilegesfromJIMusingthiscommand:SQL>REVOKESELECT,INSERT,UPDATEONempFROMjim;WhichstatementistrueafterHRissuestheREVOKEcommand()
A.ThecommandfailsbecauseSCOTTstillhasprivileges.
B.ThecommandsucceedsandprivilegesarerevokedfromJIM.
C.ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.
D.ThecommandsucceedsandonlyHRhastheprivilegetoperformtheSELECT,INSERT,andUPDATEoperationsontheEMPtable.
参考答案