1). It would be a huge improvement to have the drop down filters in datagrid + datagrid 2 only show options that are in the actual list being filtered.
2). If that isn't performant/easy then can we have the dropdown filters apply entity level security.