How to grant permissions on Hive dummy database/dummy table

[#1]

I received the following error using date functions in Hive. How are are permissions granted on dummy database/dummy table?

0:
jdbc:hive2://xxx:xxx,> SELECT DATE_ADD('2017-12-21', 1);

Error:
Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxx] does
not have [SELECT] privilege on [_dummy_database/_dummy_table]
(state=42000,code=40000)

[#2 · Accepted solution]

@Carol Elliott

You can grant workaround by creating Ranger policy on _dummy_database. Ranger doesn't really check the database, just grant full access on _dummy_database to all. Guess you are hitting the same HIVE-11498 bug which I have already experienced.

Hope this helps you.

[#3]

This worked for us. Thank you, @Sridhar Reddy.