hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sekhon (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12241) SQLStdAuth grant on <db>.* not recognized
Date Fri, 23 Oct 2015 09:33:27 GMT
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)

Mime
View raw message