I suggest the entire resource SqlPermission should be refactored to remove Ensure parameter. It should instead have the parameters Permission, PermissionToInclude, and PermissionToExclude. The PR #1769 has done such refactor on SqlDatabasePermission. I think we need to do a similar refactor on this resource.
I suggest the entire resource SqlPermission should be refactored to remove Ensure parameter. It should instead have the parameters
Permission
,PermissionToInclude
, andPermissionToExclude
. The PR #1769 has done such refactor on SqlDatabasePermission. I think we need to do a similar refactor on this resource.Originally posted by @johlju in https://github.com/dsccommunity/SqlServerDsc/issues/1761#issuecomment-1197828055