[ https://issues.apache.org/jira/browse/IMPALA-7002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16606352#comment-16606352 ]
Tim Armstrong commented on IMPALA-7002: --------------------------------------- [~fredyw] do you think the fix is straightforward? Might be a good newbie task. > Referencing non-existent table/database in CTE without any privilege results > in AnalysisException and not AuthorizationException > -------------------------------------------------------------------------------------------------------------------------------- > > Key: IMPALA-7002 > URL: https://issues.apache.org/jira/browse/IMPALA-7002 > Project: IMPALA > Issue Type: Bug > Components: Frontend > Affects Versions: Impala 2.10.0, Impala 2.11.0, Impala 2.12.0 > Reporter: Fredy Wijaya > Priority: Major > Labels: security > > {noformat} > A CTE from non-existent database. > [localhost:21000] default> with t as (select id from nodb.alltypes) select * > from t; > Query: with t as (select id from nodb.alltypes) select * from t > Query submitted at: 2018-05-09 12:31:29 (Coordinator: http://impdev-dev:25000) > ERROR: AnalysisException: Could not resolve table reference: 'nodb.alltypes' > A normal select from non-existent database. > [localhost:21000] default> select id from nodb.alltypes; Query: select id > from nodb.alltypes > Query submitted at: 2018-05-09 12:32:58 (Coordinator: > http://fwijaya-dev:25000) > ERROR: AuthorizationException: User 'impdev' does not have privileges to > execute 'SELECT' on: nodb.alltypes > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org