Oracle new table is not accessible with only table name

I have inherited a Oracle 10.2 database witch I have to extend with new tables...

On the test database I just add table and grant select privileges to the "non root" user and it works.

I do the same on the production database and I can't select from the table. It only works if I do "select * from table_space.tablename" not "select * f开发者_JAVA技巧rom tablename".

Do I have to add some kind of alias or something?

You probably need a synonym for the table.

See here and here

Also, try a select * from all_synonyms; first to see if a generic user is accessing the table through a synonym (as I suspect).