mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 04:51:11 -05:00
5d35fdc326
Allow moderators to resolve rate limit alerts by adding UPDATE policy on rate_limit_alerts and granting UPDATE to authenticated users. This completes enabling the Resolve action for alerts.
22 lines
524 B
SQL
22 lines
524 B
SQL
-- Add UPDATE policy for resolving alerts
|
|
CREATE POLICY "Moderators can resolve alerts"
|
|
ON public.rate_limit_alerts
|
|
FOR UPDATE
|
|
TO authenticated
|
|
USING (
|
|
EXISTS (
|
|
SELECT 1 FROM public.user_roles
|
|
WHERE user_id = auth.uid()
|
|
AND role IN ('admin', 'moderator', 'superuser')
|
|
)
|
|
)
|
|
WITH CHECK (
|
|
EXISTS (
|
|
SELECT 1 FROM public.user_roles
|
|
WHERE user_id = auth.uid()
|
|
AND role IN ('admin', 'moderator', 'superuser')
|
|
)
|
|
);
|
|
|
|
-- Grant UPDATE permission
|
|
GRANT UPDATE ON public.rate_limit_alerts TO authenticated; |