The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useParams } from 'common'
import { UnlockIcon } from 'lucide-react'
import Link from 'next/link'
import { Button, Popover, PopoverContent, PopoverTrigger } from 'ui'
import { type Lint } from '@/data/lint/lint-query'
export const SecurityDefinerViewPopover = ({
lint,
onAutofix,
}: {
lint: Lint | null
onAutofix?: () => void
}) => {
const { ref } = useParams()
return (
<Popover modal={false}>
<PopoverTrigger asChild>
<Button variant="warning" icon={<UnlockIcon strokeWidth={1.5} />}>
Security Definer view
</Button>
</PopoverTrigger>
<PopoverContent className="min-w-[395px] text-sm" align="end">
<h4 className="flex items-center gap-2">
<UnlockIcon size={14} /> Secure your view
</h4>
<div className="grid gap-2 mt-2 text-foreground-light text-sm">
<p>
This view is defined with the Security Definer property, giving it permissions of the
view's creator (Postgres), rather than the permissions of the querying user.
</p>
<p>Since this view is in the public schema, it is accessible via your project's APIs.</p>
<div className="mt-2 flex items-center gap-2">
{!!onAutofix && (
<Button variant="secondary" onClick={onAutofix}>
Autofix
</Button>
)}
<Button asChild>
<Link
target="_blank"
rel="noopener noreferrer"
href={`/project/${ref}/advisors/security?preset=${lint?.level}&id=${lint?.cache_key}`}
>
Learn more
</Link>
</Button>
</div>
</div>
</PopoverContent>
</Popover>
)
}