1. Use Cases and Motivations

1.1   Hive Privilege Changes as Result of SQL Object Changes

SQL “DROP TABLE/DATABASE” command would like to have all the privileges directly on the table/database to be deleted automatically from Ranger. 

Similarly, SQL “RENAME TABLE” command would like to have all the privileges directly on the table to be changed to the renamed table.

One more use case is SQL drop/rename column commands would like to see the privileges directly on the column(s) to be adjusted accordingly.