Consider TABLE1 it's owner is A and we have one more user B
I m gonnna create synonym for TABLE1 as SYNONYM1 by using command
by entering the Oracle DB in user A Then I m granting the permission to B for select,insert,modify for the synonym SYNONYM1
then when i select the synonym with the user B i getting the error as ORA-00980Synonym transalation is no longer valid Can anyone help for the above problem?