[jira] [Resolved] (IMPALA-7325) SHOW CREATE VIEW on a view that references built-in functions requires access to the built-in database

["Fredy Wijaya (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-7325?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fredy Wijaya resolved IMPALA-7325.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.1.0

> SHOW CREATE VIEW on a view that references built-in functions requires access to the built-in database
> ------------------------------------------------------------------------------------------------------
>
>                 Key: IMPALA-7325
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7325
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 3.0, Impala 2.12.0
>            Reporter: Fredy Wijaya
>            Assignee: Fredy Wijaya
>            Priority: Major
>              Labels: security
>             Fix For: Impala 3.1.0
>
>
> {noformat}
> [localhost:21000] default> create table foo.t(i int);
> [localhost:21000] default> create view foo.v1 as select count(*) from foo.t;
> [localhost:21000] default> create view foo.v2 as select * from foo.t;
> [localhost:21000] default> grant select on database foo to role foo_role;
> [localhost:21000] default> show create view foo.v1;
> Query: show create view foo.v1
> ERROR: AuthorizationException: User 'impdev' does not have privileges to see the definition of view 'foo.v1'.
> [localhost:21000] default> show create view foo.v2;
> Query: show create view foo.v2
> +-----------------------+
> | result                |
> +-----------------------+
> | CREATE VIEW foo.v2 AS |
> | SELECT * FROM foo.t   |
> +-----------------------+
> Fetched 1 row(s) in 0.01s
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)