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?
