The REVOKE statement removes one or more already-granted (or denied) permissions.
This statement has the following syntax:
REVOKE [GRANT OPTION FOR] permission_list [ON scope]
FROM principal_list [CASCADE]
[AS {windows_group|sqlserver_login|db_user|db_role|appl_role}]
REVOKE SELECT ON project
FROM PUBLIC