Current NTFS ACES Without Inheritance
How when using the srs.current_ntfs_aces view can I report on the ACES without inheritance?
The srs.current_ntfs_aces view includes a field called ace_flags which is a value mask. If this ace_flags value when ANDed with the a decimal value of 16 is equal to 16 than the ACE is inherited. If we therefore mask off that bit mask we can filter off the inherited values.
Select * From srs.current_ntfs_aces Where ace_flags & 16 <> 16