Is it possible to get permissions of attached database files via powershell?

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  March 29, 2018 at 9:44 am

  #410376

  I had a problem recently where the permissions on a database file were wrong and I wanted an automated way to check for it

  put together something really simple but it doesn't work on files currently attached by SQL. Only works if I detach a database. I have also tried get-acl with the same result. Is there something I'm missing?

• $data_folder = "f:\data"
  $logs_folder = "g:\logs"
  $files = Get-ChildItem $data_folder
  foreach ($file in $files)
    {
     $Path = $file.FullName
    $Acl = (Get-Item $Path).GetAccessControl('Access')
    $Username = $HomeFolder.Name
    #$Ar = New-Object System.Security.AccessControl.FileSystemAccessRule($Username, 'Modify','ContainerInherit,ObjectInherit', 'None', 'Allow')
    #$Acl.SetAccessRule($Ar)
    #Set-Acl -path $Path -AclObject $Acl
    }
    return $path