在對(duì)應(yīng)表右鍵>屬性>權(quán)限

找到指定賬戶(hù)

在拒絕那里勾選相應(yīng)權(quán)限

語(yǔ)句：

UPDATE,SELECT,DELETE 多個(gè)權(quán)限用逗號(hào)分開(kāi)

-----對(duì)用戶(hù)member授權(quán)，允許其具有對(duì)數(shù)據(jù)表person的更新和刪除的操作權(quán)限：

GRANT UPDATE,DELETE ON person
TO member WITH GRANT OPTION??

--WITH GRANT OPTION表示該用戶(hù)可以向其他用戶(hù)授予他所擁有的權(quán)限；

-----禁止member用戶(hù)對(duì)數(shù)據(jù)表person的更新權(quán)限：
DENY UPDATE ON person?TO member CASCADE;

-----收回用戶(hù)member對(duì)person表的刪除權(quán)限：
REVOKE DELETE ON person FROM member