xDatabase
xDatabase copied to clipboard
xDatabase does not seem to apply DB permissions for "newly" added DB objects.
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.