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.

[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.

[rindev0901]

@TangSirOnGit You can implement service_role like this below code

export function createClient({ admin }: Props = { admin: false }) {
  const cookieStore = cookies();

  if (admin) {
    const env = process.env.NODE_ENV;
    return createServerClient<Database>(
      process.env.NEXT_PUBLIC_SUPABASE_URL!,
      env === "development"
        ? process.env.NEXT_PRIVATE_SUPABASE_SERVICE_ROLE_KEY_DEVELOPMENT!
        : process.env.NEXT_PRIVATE_SUPABASE_SERVICE_ROLE_KEY_PRODUCTION!,
      {
        cookies: {
          getAll() {
            return [];
          },
        },
      }
    );
  }

  return createServerClient<Database>(
    process.env.NEXT_PUBLIC_SUPABASE_URL!,
    process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!,
    {
      cookies: {
        getAll() {
          return cookieStore.getAll();
        },
        setAll(cookiesToSet) {
          try {
            cookiesToSet.forEach(({ name, value, options }) =>
              cookieStore.set(name, value, options)
            );
          } catch {
            // The `setAll` method was called from a Server Component.
            // This can be ignored if you have middleware refreshing
            // user sessions.
          }
        },
      },
    }
  );
}