© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•3y ago•
4 replies
Christian

After update on Auth.users.last_sign_in result in "Database Error Granting User" error

I have a last_sign_in_at column in my user_profiles table, which should be updated via the auth.users table when a user signs in. But seems like if I do any AFTER UPDATE on auth.users, the db gives me an error 500 "Database Error Granting User" (when signing in). Seems like the function isn't the problem, but I could be something to do with the trigger. Eg. After insert work with the same function.
image.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

500: Database error granting user
SupabaseSSupabase / help-and-questions
2mo ago
Sign Up / Sign In, Users management and auth error
SupabaseSSupabase / help-and-questions
2mo ago
Create `Database Webhook` on `auth.users` ?
SupabaseSSupabase / help-and-questions
4y ago
Assigning auth users to different 'user type' tables on sign up?
SupabaseSSupabase / help-and-questions
3y ago