Who owns the objects?
The browser only shows objects owned by the current logged in user in the main section. You need to go into the Other Users node to find objects owner by other users.
I can see all tables and view under "Other Users" but how do I run a select statement?
There is a table db named "COURSES" under "Other Users" and I want to select top 10 records from a table named "Selection"