Security Advisor falsely flags standard SQL view as "Security Definer View"

[KwamyAG]

Bug Report: Security Advisor falsely flags standard SQL view as "Security Definer View"

Description

The Supabase Security Advisor is incorrectly flagging a standard SQL view (public.view_unified_messages) as having SECURITY DEFINER property, which is not possible for views in PostgreSQL.

This is causing a persistent ERROR that cannot be resolved via valid SQL fixes.

Steps to Reproduce

1. Create a simple view:

   CREATE VIEW public.view_unified_messages AS
   SELECT id, conversation_id, sender_id, content, ... FROM public.messages;

Evidence

SELECT schemaname, viewname, viewowner, definition
FROM pg_views 
WHERE viewname = 'view_unified_messages';

Result:

schemaname | viewname               | viewowner | definition
-----------|------------------------|-----------|-----------
public     | view_unified_messages  | postgres  | SELECT id, conversation_id, ... FROM messages;