I created a user ABC...and then logged in as Scott to grant select on EMP to ABC...and grant suceeded...But when ABC logged in wants to query EMP it says table doesnt exist...Y is that...i am on win2k and 9.2...Thanks in advance
Thanks for reply but if logged in as SYS and say
grant select on scott.emp to ABC and then grant suceeded
after that ABC should be able to query by saying
select * from emp;
But ABC cant he gets mssg that table doesnt exist..y u need to create synonym for that...