Hi Russ.
One would like to have the ability to specify the filter in the same way as other things in SB can be filtered by constructing a where clause
Ok, but that's usually for lists of objects in the LHS. We rarely have such filters for RHS schema browser tabs. I'm not saying we shouldn't, just that we aren't being inconsistent here.
That dialog in your screen shot is a generic grid filter. It's in most every grid in Toad. It is not supposed to be aware of SQL. It just checks for values in the underlying dataset based on filter conditions and then shows or hides them.
I guess I could add a view/edit query button, or even a filter button with a GUI, but the "how granted" column of the grid is constructed in our code by processing the results, so I'm not sure you'll be able to do everything you want here. User may just find that tab more usable in tree mode. Then you can ignore DBA or whatever by not expanding that node.
