What is the best way to access all users from the auth.users table?

[RafaelCENG]

Hello everyone I'm trying to access my auth.users table from the client side. I have an admin account where I want to use data like email, last login, etc. I do not want to create a new table based on auth.users. Is my best option to use a view? Also, I tried something like this:

    console.log(supabase.auth.admin.listUsers().then((test) => test.data));

Which is wrong based on the docs. (Also getting unauthorized error)
I managed to get my current user with getSession() but I need the whole table.

[GaryAustin1]

The API has no access to the auth schema. You might be able to use a view. A security definer function called with rpc would work. The issue with both approaches is you will need to protect the view or rpc call so a normal user can’t call it.

[GaryAustin1]

It has Never been possible to access the auth schema from the REST API. It is not allowed in the API schema settings and none of the API roles have grants on it.
All you can do is use security definer functions to access it from an rpc call.

Edit. The database port should have access to it if that is what you mean, but that is not considered an API.

[TangSirOnGit]

As an application administrator, if I want to list the number of registered users on the admin dashboard，

I attempted to retrieve user data using the following method from the documentation:

const {
    data: { users },
    error,
  } = await supabase.auth.admin.listUsers({
    page: 1,
    perPage: 1000,
  });

However, the resulting user list is empty.

[GaryAustin1]

@TangSirOnGit You should check the error returned. Is your client initialized with service_role?

[TangSirOnGit]

Hey, @GaryAustin1 thank you for reply,
the error message:

users: []
error: AuthApiError: User not allowed
at handleError (webpack-internal:///(rsc)/./node_modules/@supabase/gotrue-js/dist/module/lib/fetch.js:46:11)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async _handleRequest (webpack-internal:///(rsc)/./node_modules/@supabase/gotrue-js/dist/module/lib/fetch.js:93:9)
at async _request (webpack-internal:///(rsc)/./node_modules/@supabase/gotrue-js/dist/module/lib/fetch.js:73:18)
at async GoTrueAdminApi.listUsers (webpack-internal:///(rsc)/./node_modules/@supabase/gotrue-js/dist/module/GoTrueAdminApi.js:153:30)
at async Component (webpack-internal:///(rsc)/./app/admin/(overview)/page.jsx:35:40) {
__isAuthError: true,
status: 401
}

how to initialize the client with 'service_role' ?

thank you!

[Donald646]

No I'm pretty sure this is cause you need the admin client.