Configure a resource-based storage handler policy: HadoopSQL
How to configure a policy that allows authorized users to create data tables using storage-handlers.
Ranger includes “storage-type” and “storage-url” resources in HadoopSQL Service that support only the “RW Storage ” permission. Ranger authorizes users to create or alter tables against this resource policy. Users are allowed to create/alter the table in the respective storage if they have the required “RW Storage” permission on the resource representing the storage-type and storage-url .
- HBase StorageHandler policy:
- Storage Type: hbase
- Iceberg StorageHandler policy:
- Storage type: iceberg
- JDBC StorageHandler policy:
- Storage Type: jdbc:mysql
- Kafka StorageHandler policy:
- Storage Type: kafka
- Phoenix StorageHandler policy:
- Storage Type: phoenix