Powershell DSC xSQLServer help

I was hoping someone would be able to help me, im no DBA admin so this might be simple.

I have been asked to get SQL installed to a number of dev machines which need rebuilding every so often using DSC. This is so we can trial DSC to see if we can use it in production.

As part of our standard SQL configuration we run the following command

Revoke execute on <Stored Procedure> from public

I am trying to translate this command into DCS using the xSQLServer module, however unsure which resource I should use. I would have through it would have been xSQLServerPermission, however looking at the parameters, it does not seem to be the case

Any help would be great thank you.

submitted by /u/znos65
[link] [comments]

Leave a Reply