[
https://issues.apache.org/jira/browse/HIVE-20104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
tu gongxuan reassigned HIVE-20104:
----------------------------------
Assignee: zhaoyingchao
> Revoke privilege failure
> ------------------------
>
> Key: HIVE-20104
> URL: https://issues.apache.org/jira/browse/HIVE-20104
> Project: Hive
> Issue Type: Bug
> Components: Security
> Affects Versions: 1.1.0
> Reporter: tu gongxuan
> Assignee: zhaoyingchao
> Priority: Minor
>
> I want to revoke the prilege from user,sometimes failure.
> throught beeline ,show user likai privilege as following using show grant
> user likai;
> 0: jdbc:hive2://172.29.61.12:10000> show grant user likai;
> INFO : Compiling
> command(queryId=hive_20180706161515_0768d0e5-84a5-4601-9fdf-ab37a938188c):
> show grant user likai
> INFO : Semantic Analysis Completed
> INFO : Returning Hive schema:
> Schema(fieldSchemas:[FieldSchema(name:database, type:string, comment:from
> deserializer), FieldSchema(name:table, type:string, comment:from
> deserializer), FieldSchema(name:partition, type:string, comment:from
> deserializer), FieldSchema(name:column, type:string, comment:from
> deserializer), FieldSchema(name:principal_name, type:string, comment:from
> deserializer), FieldSchema(name:principal_type, type:string, comment:from
> deserializer), FieldSchema(name:privilege, type:string, comment:from
> deserializer), FieldSchema(name:grant_option, type:boolean, comment:from
> deserializer), FieldSchema(name:grant_time, type:bigint, comment:from
> deserializer), FieldSchema(name:grantor, type:string, comment:from
> deserializer)], properties:null)
> INFO : Completed compiling
> command(queryId=hive_20180706161515_0768d0e5-84a5-4601-9fdf-ab37a938188c);
> Time taken: 0.001 seconds
> INFO : Executing
> command(queryId=hive_20180706161515_0768d0e5-84a5-4601-9fdf-ab37a938188c):
> show grant user likai
> INFO : Starting task [Stage-0:DDL] in serial mode
> INFO : Completed executing
> command(queryId=hive_20180706161515_0768d0e5-84a5-4601-9fdf-ab37a938188c);
> Time taken: 0.041 seconds
> INFO : OK
> +-----------+-------------------------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+--+
> | database | table | partition | column |
> principal_name | principal_type | privilege | grant_option | grant_time
> | grantor |
> +-----------+-------------------------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+--+
> | tmp | | | | likai
> | USER | SELECT | false | 1476865827000 |
> admin |
> | tmp | 0530_zhonganbaimingdan | | | likai
> | USER | SELECT | false | 1527755292000 |
> admin |
> | tmp | aes_20180307 | | | likai
> | USER | ALL | true | 1520405354000 |
> likai |
> | tmp | houyue_20180523 | | | likai
> | USER | ALL | true | 1527064113000 |
> likai |
> | tmp | houyue_3des_20180809 | | | likai
> | USER | ALL | true | 1518155793000 |
> likai |
> | tmp | houyue_encry_20180208 | | | likai
> | USER | ALL | true | 1518071185000 |
> likai |
> | tmp | houyue_encry_base64_20180208 | | | likai
> | USER | ALL | true | 1518079661000 |
> likai |
> | tmp | houyue_test_20180127 | | | likai
> | USER | ALL | true | 1517034444000 |
> likai |
> +-----------+-------------------------------+------------+---------+-----------------+-----------------+------------+---------------+----------------+----------+--+
> 8 rows selected (0.054 seconds)
>
> 0: jdbc:hive2://172.29.61.12:10000> revoke select on database tmp from user
> likai;
> INFO : Compiling
> command(queryId=hive_20180706161515_cb1ca248-e891-4315-8f53-fb9c7ae5c355):
> revoke select on database tmp from user likai
> INFO : Semantic Analysis Completed
> INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
> INFO : Completed compiling
> command(queryId=hive_20180706161515_cb1ca248-e891-4315-8f53-fb9c7ae5c355);
> Time taken: 0.001 seconds
> INFO : Executing
> command(queryId=hive_20180706161515_cb1ca248-e891-4315-8f53-fb9c7ae5c355):
> revoke select on database tmp from user likai
> INFO : Starting task [Stage-0:DDL] in serial mode
> ERROR : FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask.
> org.apache.hadoop.hive.ql.metadata.HiveException:
> org.apache.thrift.transport.TTransportException
> INFO : Completed executing
> command(queryId=hive_20180706161515_cb1ca248-e891-4315-8f53-fb9c7ae5c355);
> Time taken: 1.044 seconds
> Error: Error while processing statement: FAILED: Execution Error, return code
> 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
> org.apache.hadoop.hive.ql.metadata.HiveException:
> org.apache.thrift.transport.TTransportException (state=08S01,code=1)
>
> if I grant another privilege to user likai,and revoke the privilege from
> likai rightnow, it works.
> but sometimes (not right now), it failure
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
