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.
精彩评论