I am logging in with a user that has 'SELECT_CATALOG_ROLE' and privilege 'ALL_VIEWS' and cannot see any source code from other users as I change schemas when I set my connections using VS code.
I have tried using the other schemas option to log in as. I have also tried using the connection settings to pass in those values in the dBAPrivilege property among others.
Please advise how to replicate this option available on SQL developer and other editors.
Miguel