Rules security issues
These rules are not secured:
"186873436","root",2019-06-11T13:20:43.188+02:00,"root",2019-06-11T13:20:43.188+02:00,"R",NULL,"SELECT sample FROM Sample sample JOIN sample.datasets dataset JOIN dataset.dataCollectionDatasets dataCollectionDatasets JOIN dataCollectionDatasets.dataCollection dataCollection WHERE dataCollection.doi <>null"
"142846999","root",2018-11-07T10:49:47.610+01:00,"root",2018-11-07T10:49:47.610+01:00,"R",NULL,"SELECT dataset FROM Dataset dataset JOIN dataset.dataCollectionDatasets dataCollectionDatasets JOIN dataCollectionDatasets.dataCollection dataCollection WHERE dataCollection.doi <> null"
"142847000","root",2018-11-07T10:49:59.830+01:00,"root",2019-03-19T16:34:47.860+01:00,"R",NULL,"SELECT datasetParameter FROM DatasetParameter datasetParameter JOIN datasetParameter.dataset dataset JOIN dataset.dataCollectionDatasets dataCollectionDatasets JOIN dataCollectionDatasets.dataCollection dataCollection WHERE dataCollection.doi <> null"
"142901599","255362",2018-11-07T15:08:48.269+01:00,"255362",2018-11-07T15:08:48.269+01:00,"R",NULL,"SELECT datafile FROM Datafile datafile JOIN datafile.dataset dataset JOIN dataset.dataCollectionDatasets dataCollectionDatasets JOIN dataCollectionDatasets.dataCollection dataCollection WHERE dataCollection.doi <> null"
They allow to potentially read all datasets for a sample if the sample has at least one dataset within a dataCollection containing a DOI
Tested on ovm-icat-test:
https://ovm-icat-test.esrf.fr:8181/icat/entityManager?sessionId=5f2a2039-594c-4177-9454-617f125f565d&query=select s from Sample s where s.name= 'quant ' include s.datasets
Query returns two datasets when only one dataset is public