Từ chối quyền thực thi trên CSDL
DENY ALL | [,…]
[ ( column [ ,...n ] ) ] ON { table | view }
| ON table | view [ ( column [ ,...n ] ) ]
| ON stored_procedure
TO
Ví dụ: USE QLDeTai
GO
GRANT SELECT ON DeTai TO public
GO
DENY SELECT, INSERT, UPDATE, DELETE
ON DeTai TO Mary, John, Tom