Thank you for reaching out to Microsoft Q & A forum.
In ASP.NET Core Identity (including version 8), there is currently no built-in configuration option to automatically save access or refresh tokens to the AspNetUserTokens table without writing custom logic. The default behavior only supports storing tokens from external authentication providers.
Since you're not using JWT or any third-party authentication, you will need to manually save tokens using the UserManager service. For example:
await userManager.SetAuthenticationTokenAsync(user, "MyApp", "AccessToken", token);
At this time, configuring token storage solely through Program.cs is not supported. So, a small amount of custom implementation is necessary to store these tokens as part of your authentication flow.
If you have found the answer provided to be helpful, please click on the "Accept answer/Upvote" button so that it is useful for other members in the Microsoft Q&A community.