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




Reply With Quote