iotdb icon indicating copy to clipboard operation
iotdb copied to clipboard

Non-root users with correct query privileges are unable to select a empty timesereis

Open SteveYurongSu opened this issue 4 years ago • 1 comments

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: image

SteveYurongSu avatar Nov 15 '21 09:11 SteveYurongSu

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

panlw avatar Oct 28 '22 07:10 panlw