Is it possible to DROP TABLE but not DROP DATABASE in Hive using Ranger Hive Plugin?

[#1]

- Is it possible to DROP TABLE but not DROP DATABASE in Hive using Ranger Hive Plugin on latest version of HDP?

[#2]

DROP TABLE IF EXISTS tableName;

[#3]

@sulanta thanks but my requirement is little different. What I want is to restrict the user from dropping the database but that user should be able to drop the table. Is this possible?

[#4]

The above command does not drop the database , it will only drop the specific table mentioned in the command.

[#5]

I have same issue. Did you get an answer please?