Posts: 15
Registered: ‎04-23-2015

How to explain plan for unaccessible underlying table in view


We need to implement RLS (row level security) in Impala, and it works over VIEWs with some filtering and projections. Users have SELECT access to view, but does not have access to underlying table (it should hide some secret rows). But where is a problem here: when you want to explain plan for query, containing that VIEW, you got error:


ERROR: AuthorizationException: User 'test' does not have privileges to EXPLAIN this statement.

Is where any workaround for this issue?