# Export project roles dataset

**URL:** <https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624>\
**Category:** General Discussion\
**Tags:** ignition79\
**Created:** [March 23, 2026, 4:17pm UTC](https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624 "2026-03-23T16:17:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rodney.oliveira1](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@rodney.oliveira1](https://forum.inductiveautomation.com/u/rodney.oliveira1)\
**Post date:** [March 23, 2026, 4:17pm UTC](https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624/1 "2026-03-23T16:17:39Z")

</div>

Is there any way to export a dataset with the all the projects and their client required roles, similar with the page “configure \> security \> user,roles”, instead of opening each project and checking in the properties one by one?

---

<div class="post-metadata">

**Author:** ![dillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dillon/32/81537_2.png) [@dillon](https://forum.inductiveautomation.com/u/dillon)\
**Post date:** [March 23, 2026, 5:54pm UTC](https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624/2 "2026-03-23T17:54:39Z")

</div>

If it's an internal usersource, you could use a tool like [GitHub - inductiveautomation/kindling](https://github.com/inductiveautomation/kindling) to read the sqlite file and then find the table that stores the roles.

Update: Linked the wrong tool initially 🫢

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 23, 2026, 6:01pm UTC](https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624/3 "2026-03-23T18:01:37Z")

</div>

There's nothing built in that can do this easily. Kindling won't help in this particular case because this is data stored in the project - while projects are technically in the idb in 7.9, in both 7.9 and 8.x the 'global props' resource that holds this information is gzipped Java serialized data. Not particularly human friendly to work with.

In theory, you could write a gateway script that works through all the projects and exports this information. In practice, writing that script would probably take longer than just clicking through all the projects manually.

---

<div class="post-metadata">

**Author:** ![rodney.oliveira1](https://avatars.discourse-cdn.com/v4/letter/r/7c8e57/32.png) [@rodney.oliveira1](https://forum.inductiveautomation.com/u/rodney.oliveira1)\
**Post date:** [March 23, 2026, 6:35pm UTC](https://forum.inductiveautomation.com/t/export-project-roles-dataset/114624/4 "2026-03-23T18:35:13Z")

</div>

Understood. Probably will be quicker to make this manually, I’m building an access matrix and after that I’ll just need to update the matrix for any change or new project. Thank you!