Hi team, i have thousands of users for which i need to apply rls, so is there any dynamic way , or i have to onboard the users and add them in broker.conf?
pinot.broker.access.control.principals.alice.password=alice123
pinot.broker.access.control.principals.admin.password=admin
pinot.broker.access.control.principals.alice.tables=user_data_REALTIME
pinot.broker.access.control.principals.alice.user_data_REALTIME.rls=userId='102'
Arnav
12/02/2025, 6:25 AM
fyi @Mayank@Xiang Fu please help here
x
Xiang Fu
12/02/2025, 8:04 AM
this acl is config based
Xiang Fu
12/02/2025, 8:04 AM
you can try to use zookeeper based and have your own script to manage users
In this also user needed to onboarded via api then restart the servers and brokers. Is there any other better way?
x
Xiang Fu
12/02/2025, 12:07 PM
no need to restart
Xiang Fu
12/02/2025, 12:08 PM
Hot Deployment is supported when updating authentication information
a
Arnav
12/03/2025, 4:23 AM
ok
using this i can manage this usecase that user1 have read access to table1 and user1 can see only rows where customer_id (column in table1) = user1?
x
Xiang Fu
12/03/2025, 7:54 AM
acl is on table level only, no row or column level acl
a
Arnav
12/03/2025, 10:01 AM
but my usecase was row level so for that i should make that logic on superset?
I was hoping that in some way pinot also provide similar rule RLS feature like superset