REVOKE Statement : REVOKE « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. REVOKE
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








28.8.REVOKE
28.8.1.REVOKE Statement
28.8.2.REVOKE permissions
28.8.3.A REVOKE statement that revokes SELECT permission
28.8.4.A REVOKE statement that revokes the DELETE permission
28.8.5.A REVOKE statement that revokes all permissions for the Bankers table
28.8.6.A REVOKE statement that revokes permission to create databases and tables