假定用户WangPing创建了表RecipeDetail Medicine RecipeMaster 并且WangPing执行如下授权命令:
已帮助 人
假定用户WangPing创建了表RecipeDetail, Medicine, RecipeMaster,并且WangPing执行如下授权命令: GRANT SELECT ON RecipeDetail TO LiXia; GRANT SELECT ON RecipeMaster TO LiXia WITH GRANT OPTION; GRANT UPDATE(Mprice) ON Medicine TO WangHao; GRANT REFERENCE(Mno)ON Medicine TO ZhangYang; GRANT INSERT,DELETE ON RecipeDetail TO MengFan WITH GRANT OPTION; 以下哪个是错误的——
A.LiXia能够对RecipeDetail和RecipeMaster执行查询语句
B.LiXia能将RecipeMaster的查询权限授予DengTian
C.WangHao能够修改Medicine表中的Mprice列的值
D.WangHao能够执行UPDATE Medicine SET Mprice = Mprice-10

回答
共1条回复-
WangHao 能够执行UPDATE Medicine SET Mprice = Mprice-10
