# Table SQLite for IDP

**URL:** <https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188>\
**Category:** Ignition\
**Created:** [April 24, 2020, 10:00am UTC](https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188 "2020-04-24T10:00:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![giuseppe.teobaldo](https://avatars.discourse-cdn.com/v4/letter/g/e0b2c6/32.png) [@giuseppe.teobaldo](https://forum.inductiveautomation.com/u/giuseppe.teobaldo)\
**Post date:** [April 24, 2020, 10:00am UTC](https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188/1 "2020-04-24T10:00:53Z")

</div>

I would need to know in which table of the SQLite I find the names of the Identify Providers users set in the user grants section.  
Thank you

---

<div class="post-metadata">

**Author:** ![jspecht](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jspecht/32/6465_2.png) [@jspecht](https://forum.inductiveautomation.com/u/jspecht)\
**Post date:** [April 24, 2020, 2:58pm UTC](https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188/2 "2020-04-24T14:58:43Z")

</div>

IdP configs are stored in the `IDP_ADAPTERS` table

---

<div class="post-metadata">

**Author:** ![giuseppe.teobaldo](https://avatars.discourse-cdn.com/v4/letter/g/e0b2c6/32.png) [@giuseppe.teobaldo](https://forum.inductiveautomation.com/u/giuseppe.teobaldo)\
**Post date:** [April 27, 2020, 10:47am UTC](https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188/3 "2020-04-27T10:47:19Z")

</div>

Thanks for your support, but inside this table I cannot find the list of users that I created in the User Grants and the related security level set.

I would like to create queries with inserts and select options directly inside the perscpective is possible.

---

<div class="post-metadata">

**Author:** ![jspecht](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jspecht/32/6465_2.png) [@jspecht](https://forum.inductiveautomation.com/u/jspecht)\
**Post date:** [April 27, 2020, 2:39pm UTC](https://forum.inductiveautomation.com/t/table-sqlite-for-idp/34188/4 "2020-04-27T14:39:19Z")

</div>

Look in the `config` column - this is where we store the IdP config, which is a JSON object. User grants are the JSON object associated with key `directSecurityLevelPolicies`