I don’t know why but I can verify that this happens every time. I have reproduced this multiple times.
I am using a separate login that only has readonly (acct is called “readonly”) access to the tables and views I need.
Every time I click the “Save and Clear Cache” button I see that select and reference access to those tables/views are removed.
I can’t determine why but it happens every time that button gets clicked.
Is there any insight as to why this is happening?