[SENTRY-746] After revoke select from view, select fails with a confusing error message

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0, 1.6.0
• Fix Version/s: 1.6.0
• Component/s: Core
• Assignee: Colin
• Reporter: Anne Yu
• Created: 27/May/15 18:57
• Updated: 20/Jan/16 22:49
• Resolved: 31/Aug/15 00:56

Description

This is an error message issue. If user is revoked select privilege from a view, the failure reason seems confusing.

2015-05-26 22:20:56,748 (pool-16-thread-3) [INFO - org.apache.sentry.tests.e2e.minisentry.InternalSentrySrv$SentryThriftEvenHandler.deleteContext(InternalSentrySrv.java:83)] Client Disonnected: 47
FAILED: SemanticException No valid privileges
 Required privileges for this query: Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=insert;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=select;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=alter;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=create;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=drop;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=index;Server=server1->Db=test_complex_view_database->Table=*->Column=*->action=lock;

Issue Links

• relates to: SENTRY-1015 Improve Sentry + Hive error message when user does not have sufficient privileges to perform an operation