iotdb
iotdb copied to clipboard
Non-root users with correct query privileges are unable to select a empty timesereis
How to reproduce:
# user: root
CREATE USER steve 'steve'
GRANT ROLE application_role PRIVILEGES 'SET_STORAGE_GROUP','CREATE_TIMESERIES','INSERT_TIMESERIES','READ_TIMESERIES','DELETE_TIMESERIES','DROP_FUNCTION','CREATE_FUNCTION','CREATE_TRIGGER','DROP_TRIGGER','START_TRIGGER','STOP_TRIGGER' ON root.test
GRANT application_role TO steve
# user: steve
select sin(s1) from root.test where time >= 2021-01-01 and time<= 2021-01-31 23:59:59
Then, you will get:

grant user m3app PRIVILEGES READ_TIMESERIES on root.**
-- login by m3app
select * from root.mk001.0.*
Msg: 602: No permissions for this operation, please add privilege READ_TIMESERIES