permissions on views

linjoehan

I'm strange permissions that just vanish. Here USER can see both views in se_reports

 

 

USER=> \dv
                    List of views
   Schema   |        Name         |  Owner  | Comment
------------+---------------------+---------+---------
 se_prod    | vw_tier_penetration | dbadmin |
 se_prod    | vw_member_base      | dbadmin |
 se_reports | test_view           | USER2   |
 se_reports | vw_member_base      | USER2   |
(4 rows)

After granting permissions hes permissions on one of the views vanish

 

dbadmin=> GRANT SELECT ON ALL TABLES IN SCHEMA se_reports TO USER;
GRANT PRIVILEGE

USER=> \dv
                    List of views
   Schema   |        Name         |  Owner  | Comment
------------+---------------------+---------+---------
 se_prod    | vw_tier_penetration | dbadmin |
 se_prod    | vw_member_base      | dbadmin |
 se_reports | test_view           | USER2   |
(3 rows)

 

 Any ideas on why this would happen?