开发者

Oracle new table is not accessible with only table name

开发者 https://www.devze.com 2023-04-12 08:26 出处:网络
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 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).

0

精彩评论

暂无评论...
验证码 换一张
取 消