hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12241) SQLStdAuth grant on <db>.* not recognized
Date Tue, 27 Oct 2015 00:09:27 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14975396#comment-14975396
] 

Thejas M Nair commented on HIVE-12241:
--------------------------------------

You are right, there is no support for a regex on tables in grant statements in sql std authorization.
That would be nice to have.
There are more flexible granting is possible via Ranger.


> SQLStdAuth grant on <db>.* not recognized
> -----------------------------------------
>
>                 Key: HIVE-12241
>                 URL: https://issues.apache.org/jira/browse/HIVE-12241
>             Project: Hive
>          Issue Type: Bug
>          Components: Parser, SQLStandardAuthorization
>    Affects Versions: 0.14.0
>         Environment: HDP 2.2
>            Reporter: Hari Sekhon
>
> Using SQLStdAuthorizer Hive doesn't recognize doing a grant on all tables like I've done
before in RDBMS. If having a lot of tables this becomes very inconvenient to grant on a table-by-table
basis and granting on database succeeds but still doesn't allow user to query tables in that
database:
> {code}
> > grant all on myDB.* to user hari;
> Error: Error while compiling statement: FAILED: ParseException line 1:15 mismatched input
'.' expecting TO near 'myDB' in grant privileges (state=42000,code=40000)
> > grant all on myDB.`*` to user hari;
> Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table
not found myDB.* (state=42S02,code=10001)
> > grant all on `myDB.*` to user hari;  
> Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table
not found myDB.* (state=42S02,code=10001)
> > grant all on all to user hari;   
> Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table
not found myDB.all (state=42S02,code=10001)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message