Take the 2-minute tour ×

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 * from tablename".

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

share|improve this question
possible duplicate of Oracle table SELECT rights issue –  APC Oct 11 '11 at 9:09
add comment

1 Answer

up vote 4 down vote accepted

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).

share|improve this answer
I knew it was something like this! Thank you very much! –  user929542 Oct 11 '11 at 10:14
If this solves your problem it would be nice to "accept" the answer ;) –  p.marino Oct 11 '11 at 10:23
add comment

Your Answer


