PawelK.30643 (Customer) asked a question.
Maping custom data to user authenticated by okta
Let's say I want to build ToDo app with Okta authentication.
I need to store users' tasks in the relational database.
The user has to have the ability to query only his tasks.
What user property should I use as a user identifier in my database?
In access token, I can see claims like uid and sub which seems to be suitable for my needs.
Unfortunately, both of them are strings instead of numeric values.
Using them as tables' primary key seems like a very inefficient idea.
Could you recommend a better way of achieving my goal?
Thank you for contacting Okta support. My name is Andreea, and I will be handling your case.
Our users do not have base attributes that are strictly numerical. I suggest that you create a custom attribute but you will have to set that manually for each user.