Hari Sekhon created HIVE-12241:
----------------------------------
Summary: 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
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)
