title: How can I see other schemas apart from my own when connecting to an Oracle database through server explorer?
body: <p>I am attempting to add a connection to an Oracle database through Server Explorer. The 'Test' Connection' is successful, however whenever I go to view the list of tables / schemas, I can only see the one associated with my login.</p>
  
  <p>I realise this sounds silly, but when I use the same login/password through Toad for Oracle, I am still allowed to browse "All Schemas" to find the tables I want.</p>
  
  <p>Is this possible through Server Explorer? Or do I need to find a specific login for the schema I want to access?</p>
  
  <p><strong>Solution</strong> (just so it's here and not just on the OTN forums)</p>
  
  <ul>
  <li>Right-click on connection in Server Explorer</li>
  <li>Choose filters</li>
  <li>Select the "Dispalyed Schemas" row in the property grid (it should be selected by default) </li>
  <li>In the Property/Condition/Value fields, click the "..." button for Value </li>
  <li>Pick any schemas you want to see and click Ok.</li>
  </ul>
  
  <p>Conversely, instead of using the dialog that appears after clicking the "..." button, you can list the schemas separated by commas in the Value textbox.</p>