There is a table test created by info user.
To provide permissions to other user below is the syntax i have used.
create or replace synonym info1.test for info.test
GRANT SELECT,INSERT,UPDATE,ALTER,DELETE ON info.test TO info1
is it mandatory to create synonym while granting permissions to other user?
suggest me how it helps.