# Access to OpenID claims data?

**URL:** https://meta.discourse.org/t/access-to-openid-claims-data/248366
**Category:** SSO
**Tags:** openid-connect
**Created:** [December 9, 2022, 9:54am UTC](https://meta.discourse.org/t/access-to-openid-claims-data/248366 "2022-12-09T09:54:38Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![paulmelis](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@paulmelis](https://meta.discourse.org/u/paulmelis)
#### Post date: [December 9, 2022, 9:54am UTC](https://meta.discourse.org/t/access-to-openid-claims-data/248366/1 "2022-12-09T09:54:38Z")

</div>

I’ve been testing with the OpenID plugin, which made it real easy to connect to our central authentication service. What I’m wondering about is if there’s any way to use the provided claims data per account in Discourse? Initially just to view the claims values per account in Discourse (e.g. check the type of account, teacher versus student).

I’ve read [Managing group membership via authentication - #30 by david](https://meta.discourse.org/t/managing-group-membership-via-authentication/175950/30), which goes a little bit towards automated group membership, but it seems experimental and only for a specific Google OpenID-based service. So for now I’m mostly looking for a way to inspect claims data in Discourse.

---

<div class="post-metadata">

### Author: ![david](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/david/32/157490_2.png) [@david](https://meta.discourse.org/u/david)
#### Post date: [December 9, 2022, 3:51pm UTC](https://meta.discourse.org/t/access-to-openid-claims-data/248366/2 "2022-12-09T15:51:22Z")

</div>

You should be able to use the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin to inspect the data. OpenID Connect data is all stored in the `user_associated_accounts` table

> [@Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…
