DSC_SqlPermission - "Undefined property permissionstate" error on Dsc versions >15

[sara921-spec]

Not an issue mostly, a general question!

I have a Question on this resource "DSC_SqlPermission" (Also "DSC_SqlDatabasePermission") we are currently using Sqlserverdsc version 14 and while updating the version we found that this resource is no more available in the newer versions. looking to use dsc version "17"

Error msg:
"Undefined property permissionstate" can u help me with what is the alternate resource for this ?

[sara921-spec]

@johlju ^^ if u have any thoughts on this when u get a chance

[johlju]

In v15 SqlPermission was converted to a class-based resource and refactored. in v16 SqlDatabasePermission was converted to a class-based resource and refactored.

[johlju]

It looks like we forgot to add BREAKING entry in the releases notes for this for some reason. :/ At least I can't find any such entry.

See here how to use SqlPermission going forward: https://github.com/dsccommunity/SqlServerDsc/wiki/SqlPermission

[github-actions]

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.