perhaps it was just me misundertsanding proxy connections
the problem only seems to occur when using the "advanced" tab to flag the connection as "proxy" (which i thought i had to do)
when simply defining a connection using proxy_user[target_user] as username (without ticking the proxy checkbox from the "advanced" dialog), searching actually works
i am pretty happy and can now search text through thousands of views in a cinch - neat!
just leaving the topic for now just in case someone feels like enlightening me on the advanced proxy options (the buil-in help does not really clarify it for me)
1 person found this helpful
No time to test it just now, but I see a possibly relevant bug that got fixed for 17.4 a couple days ago with this comment...
'find database object' not showing checkbox for schema when using db proxy users
- the 'current user' tracked in the Find DB Object tree should be the current session user.