I tried to do something like this, and what I ended up doing in the interim is to bake CURRENT_USER into the query, so something like this:

SELECT * FROM USERS
WHERE USER_NAME = CURRENT_USER()

The idea came from this thread: Getting grants of current user