I was wondering how to create an oracle data source using tables from a different user schema. The login I have been given owns no objects but has select permissions on all the tables in the database. When I get to the screen where it asks to select tables, no tables are showing up. If I create the data source with the schema owner name, I can see tables no problem, but that is a huge security issue.

Thanks in advance. I'm a total NOOB and am doing an evaluation to determine if pentaho will fit in our BI infrastructure.

Dan