So here we go.
We use the Filters in the Security tool which can apply predicates based on the Group.
First, open up the Security Manager
You should see this
Then click on Permissions
I then, like an ID10T used the Expression Builder to build my predicate. This was a BETWEEN, so I went to Operators and found the BETWEEN and double clicked on it. Can you see what it did?
How about now?
That's right, it says "Upper Bound" first followed by "Lower Bound"
I knew that wasn't right...but I went with it anyway.
After the "mistake", I verified in SQL.
SQL>EXEC :C := 20;Live and learn I guess. I'll never trust that thing again. One more reason to dislike GUIs.
PL/SQL procedure successfully completed.
SQL>SELECT * FROM DUAL WHERE :C BETWEEN 40 AND 10;
no rows selected
SQL>SELECT * FROM DUAL WHERE :C BETWEEN 10 AND 40;
1 row selected.