user_tab_columns object privilege....
sgalaxyJul 31 2006 — edited Jul 31 2006Hi everybody,
Although , i gave the privilege in sql*plus as user:
connect his/his
grant select on user_tab_columns to velliou <----- the grant succeeded
then , when i run the query , connected as user velliou ,
using the user specification (in other words select ...... from his.user_tab_columns..... where ......)
an error ORA-00942: table or view does not exist appears!!!!!!
Is there anything i can do to solve this kind of problem??????
Thanks,
Simon