Search code examples
sql-serverdatabase-permissionssql-grant

SQL Server revoking select

Let's suppose a user, "Bob", gets SELECT privilege from John and Bob also gets 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?)?

Solution

  • 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.