xcacls, securing SQL folders.

  • I am using xcacls to apply the FTEUser to all files/folders under \MSSQL\Log....EXCEPT *.trc files.

    Is there a way to exclude a file extention using XCACLS?

    I have run out of places to look, so I am hoping someone here can help..

    Thank you in advance,

    Al.

  • I don't believe xcacls has a parameter for everything but a particular filename pattern. You would likely have to determine the different patterns and run xcacls separately for each one. You might be able to work something out using the FOR loop:

    How to write a DOS batch file to loop through files[/url]

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply