We are using xDatabase DSC resource for our database deployments. However, when we add a new object (let's say a function) and assign 'Select' and/or 'Execute' permission on it associated to a DB login the object gets deployed on the target server, however, the permissions doesn't get applied.
Is this a known issue ?
P.S. - Temporary workaround was to explicitly assign the permissions via a post deployment script.
We are using xDatabase DSC resource for our database deployments. However, when we add a new object (let's say a function) and assign 'Select' and/or 'Execute' permission on it associated to a DB login the object gets deployed on the target server, however, the permissions doesn't get applied.
Is this a known issue ?
P.S. - Temporary workaround was to explicitly assign the permissions via a post deployment script.