Forum Stats

  • 3,768,724 Users
  • 2,252,841 Discussions
  • 7,874,696 Comments

Discussions

Oracle dev tools VS Code - How to choose "use DBA Views if available" on connect?

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