[
https://issues.apache.org/jira/browse/IMPALA-7002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenzhe Zhou resolved IMPALA-7002.
---------------------------------
Resolution: Fixed
> 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
> Assignee: Wenzhe Zhou
> 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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
