REVOKE#
Removes a previously granted or denied permission from one or more principals.
Syntax#
Arguments#
- GRANT OPTION FOR
Removes the right to grant the permission to others, while leaving the permission itself in place.
- ALL [ PRIVILEGES ] / permissions
The permissions to revoke.
- ON securable
The object the permissions apply to.
- FROM | TO principals
The users or roles to revoke the permissions from.
Examples#
REVOKE INSERT ON dbo.Product FROM analyst;