xcacls, securing SQL folders.

• alanspeckman

  Hall of Fame

  Points: 3344

  More actions

  November 19, 2008 at 12:50 pm

  #201637

  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.

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  November 19, 2008 at 8:31 pm

  #900841

  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