用看的、听的学真题
study by eyes and ears.
2019年05月系统分析师考试上午真题【基础知识】(第44-45题)
收藏
【44-45】若要将部门表Demp中name列的修改权限赋予用户Ming,并允许Ming将该限授予他人,实现的SQL语句如下:GRANT(44)ON TABLE Demp TO Ming(45);
-
ASELECT(name)
-
BUPDATE(name)
-
CINSERT(name)
-
DALL PRIVILEGES(name)
-
AFOR ALL
-
BCASCADE
-
CWITH GRANT OPTION
-
DWITH CHECK OPTION