SQL User retains rights granted by multiple users even when revoked by one or more grantors
When a SQL user is granted rights (e.g. SELECT, UPDATE, DELETE) by multiple grantors, if one or more of the grantors revokes those rights, they remain in place until all grantors revoke