SQL Server revoking select

Let's suppose a user, "Bob", gets SELECT privilege from John and Bob also get开发者_开发问答s SELECT privilege from another user Joe but this time with GRANT option.

What happens if someone revokes the select privilege with cascade? Will the select privilege be removed from Bob's account and all the accounts that Bob gave the privilege to (even if they had it before from somewhere else?)?

---

Yes, it will. Taken from http://msdn.microsoft.com/en-us/library/ms187728(v=sql.90).aspx

CASCADE

Indicates that the permission that is being revoked is also revoked from other principals to which it has been granted by this principal. When you are using the CASCADE argument, you must also include the GRANT OPTION FOR argument.