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).
精彩评论