Recommended index on email column for auth.users fails to create

# Bug report <!-- ⚠️ We receive a lot of bug reports which have already been solved or discussed. If you are looking for help, please try these first: - Docs: https://docs.supabase.com - Discussions: https://github.com/supabase/supabase/discussions - Discord: https://discord.supabase.com Before opening a bug report, please verify the following: --> - [x] I confirm this is a bug with Supabase, not with my own application. - [x] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and [Discord](https://discord.supabase.com). ## Describe the bug The Query performance dashboard on the Supabase dashboard is recommending we create an index for this query: ```sql select "id", "email" from "auth"."users" where "users"."email" = $1 limit $2 ``` The recommended index is ```sql CREATE INDEX ON auth.users USING btree (email); ``` However, if we try to create this in the dashboard using the "Create index" button, it fails with an error: `Failed to create index: Failed to run sql query: ERROR: 42501: must be owner of table users` ## To Reproduce Steps to reproduce the behavior, please provide code snippets or a repository: 1. Go to 'Query performance' tool in Supabase 2. Click on "Create index" for one related to email in auth.users 3. See error ## Expected behavior It should create the index for you ## Screenshots If applicable, add screenshots to help explain your problem. <img width="700" height="964" alt="Image" src="https://github.com/user-attachments/assets/02e7b3ae-bb99-4f67-b89d-00f051f769ce" /> ## System information - OS: [e.g. macOS, Windows] macOS - Browser (if applies) [e.g. chrome, safari] Chrome ## Additional context Add any other context about the problem here.