Grant privilege to see column names in null constraint violations when inserting in views
It seems that granting the privilege references allows the user to see the column names:

grant references on the_table to app_user;


The grant needs to be done for the base table not for the view.