Our DBA was tasked to create a "read-only" account for our database. He took an existing account privileges and changed all the "GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE" (and the like) to "GRANT SELECT" only. With the new "read-only" account, the table filtering does not work anymore, nor does the views, packages, etc. . When I select the "include synonyms" it does include some table names which are in the synonym list, but not a complete list (comparing known working account against new read-only account on same database).
I'm thinking there are some system tables missing privileges, or need more than "select" privileges. Any ideas?
SQL Developer 19.1.0.094
Oracle Database 12c Release 12.1.0.2.0