假定用户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
发布时间:2024-05-19 13:57:34