Is it possible to access the auth.users table publicly? I would like the email and created_at to be public data...

Hello @jdgamble555! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

You should be able to create a function / RPC that uses security definer and return those 2 columns.

jdgamble555 (2022-04-03)

Yes, or using the service key on server Side

ok, would it be better to just copy those values to the profiles table with a function, or do you guys suggest using a function to just get the values from auth.users table?

Depends, your profile table has any policies defined?

I can put whatever policies in there, but functions don't use policies...

Profile table is better option

got it thanks!

Thread was archived by @jdgamble555. Anyone can send a message to unarchive it.