The DENY statement prevents users from performing actions.
This statement has the following syntax form:
DENY permission_list [ON scope]
TO principal_list [CASCADE]
[AS {windows_group|sqlserver_login|db_user|db_role|appl_role}]
DENY CREATE TABLE, CREATE PROCEDURE TO peter, paul