This should work for you, but I agree on the purpose question... My personal preference is to avoid use of SQLPS at most costs as it can be a bit...

I know that this is a bit of an old thread, but this is what we uncovered that corrected this issue on a permanent basis on several of our servers...

First...

Yes, the user is still associated with the role, and no, there have been no denies added to the role or user.