Files
Joshen Lim 1de298ff31 Reinstate https://github.com/supabase/supabase/pull/45143 into latest master (#47433)
## Context

Previous PR was [here](https://github.com/supabase/supabase/pull/45143)
but it got stale with lots of conflicts so figured it'll be easier redo
it off the latest master

Moves policies page from Auth to Database under an Access Control
section along with Roles. This moves all existing files, applies
redirects, and updates urls to point to the new route

<img width="274" height="412" alt="image"
src="https://github.com/user-attachments/assets/7952c185-64ae-4355-ba36-45397efe1787"
/>

<img width="453" height="471" alt="image"
src="https://github.com/user-attachments/assets/04b3dcb3-48a5-4049-9893-d01109fb46a9"
/>


## To test
- [ ] Verify that policies now live under Database correctly

<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->
## Summary by CodeRabbit

* **New Features**
* Added a quick navigation shortcut to open **Database > Policies
(RLS)**.
* **Bug Fixes**
* Updated Policies and RLS-related links across the product to open the
**Database policies** area (menus, command palette, context actions,
alerts, and link-outs).
* Added a permanent redirect from the old **auth policies** URL to the
new **database policies** URL.
* **Documentation**
* Updated RLS Dashboard and security checklist instructions to reference
**Database > Policies**.
* **Tests**
  * Adjusted automated tests to validate the new Policies route.
<!-- end of auto-generated comment: release notes by coderabbit.ai -->
2026-06-30 18:49:33 +08:00

146 lines
4.9 KiB
TypeScript

import { keepPreviousData } from '@tanstack/react-query'
import { useDebounce } from '@uidotdev/usehooks'
import { Check, ChevronsUpDown } from 'lucide-react'
import { useMemo, useState } from 'react'
import { toast } from 'sonner'
import {
Button,
cn,
Command,
CommandEmpty,
CommandGroup,
CommandInput,
CommandItem,
CommandList,
Popover,
PopoverContent,
PopoverTrigger,
ScrollArea,
} from 'ui'
import { Admonition } from 'ui-patterns/admonition'
import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout'
import { GenericSkeletonLoader } from 'ui-patterns/ShimmeringLoader'
import { User, useUsersInfiniteQuery } from '@/data/auth/users-infinite-query'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { useRoleImpersonationStateSnapshot } from '@/state/role-impersonation-state'
import { ResponseError } from '@/types'
export const UserSelector = () => {
const { data: project } = useSelectedProjectQuery()
const state = useRoleImpersonationStateSnapshot()
const [open, setOpen] = useState(false)
const [searchText, setSearchText] = useState('')
const debouncedSearchText = useDebounce(searchText, 300)
const { data, error, isSuccess, isPending, isError } = useUsersInfiniteQuery(
{
projectRef: project?.ref,
connectionString: project?.connectionString,
keywords: debouncedSearchText.trim().toLocaleLowerCase(),
},
{ placeholderData: keepPreviousData }
)
const users = useMemo(() => data?.pages.flatMap((page) => page.result) ?? [], [data?.pages])
const impersonatingUser =
state.role?.type === 'postgrest' &&
state.role.role === 'authenticated' &&
state.role.userType === 'native'
? state.role.user
: undefined
const onSelectUser = async (user: User) => {
try {
await state.setRole({
type: 'postgrest',
role: 'authenticated',
userType: 'native',
user,
aal: 'aal1',
})
} catch (error) {
toast.error(`Failed to impersonate user: ${(error as ResponseError).message}`)
}
}
return (
<FormItemLayout isReactForm={false} label="Select which user to test as">
<Popover open={open} onOpenChange={setOpen} modal>
<PopoverTrigger asChild>
<Button
block
variant="default"
role="combobox"
size="small"
aria-expanded={open}
className={cn('justify-between', !impersonatingUser && 'text-foreground-lighter')}
iconRight={<ChevronsUpDown className="ml-2 h-4 w-4 shrink-0 opacity-50" />}
>
{impersonatingUser?.email ?? 'Select a user'}
</Button>
</PopoverTrigger>
<PopoverContent sameWidthAsTrigger className="p-0" side="bottom" align="start">
<Command shouldFilter={false}>
<CommandInput
showResetIcon
placeholder="Search for a user"
className="text-xs"
value={searchText}
onValueChange={setSearchText}
/>
{isError ? (
<Admonition showIcon={false} type="warning" className="border-0 rounded-none text-xs">
Failed to fetch users: {error.message}
</Admonition>
) : (
<CommandEmpty>No user found</CommandEmpty>
)}
<CommandList>
{isPending && (
<div className="p-2">
<GenericSkeletonLoader />
</div>
)}
{isSuccess && (
<CommandGroup>
<ScrollArea className={users.length > 7 ? 'h-full md:h-[210px]' : ''}>
{users.map((user) => {
return (
<CommandItem
key={user.id}
value={user.email}
className="cursor-pointer w-full"
onSelect={() => {
onSelectUser(user)
setOpen(false)
}}
>
<div className="w-full flex items-center justify-between">
<p className="space-x-3">
<span className="text-foreground-light">{user.email}</span>
<code className="text-code-inline text-foreground-lighter!">
{user.id?.slice(0, 8)}
</code>
</p>
{impersonatingUser?.id === user.id && <Check size={16} />}
</div>
</CommandItem>
)
})}
</ScrollArea>
</CommandGroup>
)}
</CommandList>
</Command>
</PopoverContent>
</Popover>
</FormItemLayout>
)
}