I am trying to pull a query based on roles what security privilege's are for each camera. The rights were not created and the Camera levels to propogate the rights down IE query pulls role a has rights to cameras a and what rights view/playback etc.

I have been combing through the database structure to try to figure this out any help would be greatly appreciated

Config API Client sample might be helpful for you – https://doc.developer.milestonesys.com/html/index.html?base=samples/componentsamples/configapiclient/readme.html&tree=tree_2.html