for audit purpose i want to extract a hive policy report from ranger with all permission details (eg: select, insert,update
i am using postgres to store all audit data, is it possible to extract all details from database?
Ranger provides only authorization. Actual data access needs to be done from Hive.
If you are interested in storing ranger audit data in Hive, see this article