service_role key not working locally on rpc call

CREATE OR REPLACE FUNCTION public.get_user_id_by_email(user_email text)
 RETURNS uuid
 LANGUAGE plpgsql
AS $function$
declare
  user_id uuid;
begin
  select id 
  from auth.users 
  where email = user_email 
  into user_id;

  return user_id;
end;
$function$
;

{
  code: '42501',
  details: null,
  hint: null,
  message: 'permission denied for table users'
}