Create a view with security_invoker on by joining the professional table.

[Raj-divine]

We have a view called public_user_names but that's not good because it has security issues we need to remove that and create a new view with security invoker on

Hint to create the view:

CREATE VIEW public.professionals_with_firstname AS
WITH (security_invoker=on)
SELECT 
    p.id AS professional_id,
    p.user_id,
    u.firstname
FROM 
    public.professionals p
JOIN 
    public.users u ON p.user_id = u.id;