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






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. REVOKE
To revoke permission means to remove the current set of permissions for an object and user or role.
This could have the effect of removing an explicit GRANT or DENY, if either exists.


30> REVOKE INSERT ON Product TO Paul
31> REVOKE EXEC ON spDeletePurchaseEmployee TO Paul
32>








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