[SENTRY-784] Sentry HDFS sync events should be case agnostic w.r.t to DB/Table names

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.4.0
• Component/s: Hdfs Plugin
• Assignee: Arun Suresh
• Reporter: Arun Suresh
• Created: 29/Jun/15 17:17
• Updated: 04/Mar/16 07:47
• Resolved: 04/Mar/16 07:47

Description

Problem Manifestation :

1. Assume Db with name "test_db"
2. Assume Sentry role "test_role" is given grant ALL on db test_db.
3. Create two external directories : /external/dir/temp_table1 & /external/dir/temp_table2 in HDFS.
4. login using beeline
5. use TEST_DB; (note the CAPS)
6. create a new table (say temp_table1) with location : /external/dir/temp_table1
7. log out of beeline
8. check hdfs acls/perms for the /external/dir/temp_table1 dir
9. login using beeline
10. use test_db; (NOTE: make sure this is lower-caps)
11. create a new table (say temp_table2) with location : /external/dir/temp_table2
12. log out
13. check hdfs acls/perms for the /external/dir/temp_table2 dir

Notice the ACLs/permissions returned at the end of step 8 and 13 are different..

Issue Links

• duplicates: SENTRY-885 DB name should be case insensitive in HDFS sync plugin