Update-SqlPermission - Change test for updateability

[andreasjordan]

Type of Change

• [x] Bug fix (non-breaking change, fixes #8442 )
• [ ] New feature (non-breaking change, adds functionality, fixes # )
• [ ] Breaking change (effects multiple commands or functionality, fixes # )
• [ ] Ran manual Pester test and has passed (.\tests\manual.pester.ps1)
• [ ] Adding code coverage to existing functionality
• [ ] Pester test is included
• [ ] If new file reference added for test, has is been added to github.com/dataplat/appveyor-lab ?
• [ ] Unit test is included
• [ ] Documentation
• [ ] Build system

I have not worked with the property IsUpdateable, but for AGs I can say that is it $true for the primaray and $false for the secondary.

So please review carefully.

[potatoqualitee]

Nice! Thank you 🙇🏼

[JohnnyHighhair]

I've have confirmed that issue https://github.com/dataplat/dbatools/issues/8442 ) has now been resolved. Thank you.