Title
#users-public
m

Martin Brutsche

11/14/2022, 10:34 PM
Hi there, in our company we are monitoring different physical assets and currently we have an individual database for each of these assets. This is a requirement we got. I just wanted to CREATE DATABASE in my QuestDB instance, but as it mentions "table" expected, am I right assuming, that it is not possible to have different databases within a QuestDB instance? So I suppose the only thing that I could do is to run one container for each assest and then assign these containers to different ports? Is that correct or are there other possibilities as well? Cheers Martin
Jaromir Hamala

Jaromir Hamala

11/14/2022, 10:55 PM
Hi Martin, that’s right. Right now a single QuestDB instance can host just a single database. So if a separation by table names is not sufficient for some reason then I am afraid you will have to start multiple QuestDB instances.
Pei

Pei

11/15/2022, 10:53 AM
Hi Martin, would using multiple tables possible for you use case?
m

Martin Brutsche

11/15/2022, 4:28 PM
Hi Pei, unfortunately not. At least not as long as it is not possible to set different access rights for different tables.
4:30 PM
As each of our current databases contains data of a different customer, it is currently quite easy to give access rights only to the DB that contains the data of the corresponding customer. Hence there is no risk, that a customer can access the data of another customer. If we create different tables, we have to make sure that it is possible to set the proper access rights for each one.
Pei

Pei

11/15/2022, 4:36 PM
Hmm, for now, I know that some of our open source users built an extra security layer (API) themselves to serve the need.
m

Martin Brutsche

11/15/2022, 4:40 PM
yes, this is something that we also discussed internally today. We plan to do some tests in next weeks to see what would be the best approach
Pei

Pei

11/15/2022, 4:44 PM
Cool, happy to learn more if you have any feedback after that! 🙂
m

Martin Brutsche

11/15/2022, 4:45 PM
I will post it here for sure 🙂
Nicolas Hourcard

Nicolas Hourcard

11/16/2022, 12:55 PM
hi @Martin Brutsche role based access control is going to be part of QDB Enterprise and will also be part of QDB Cloud.