I have two users mari_dba and mari_dba1.
I created table "a" in mari_dba, also created pubic synonym.
I granted select on that object to mari_dba1
dropped "a" table from mari_dba schema
At this time synonym got invalid.
recreated "a" table in mari_dba schema
after selecting Oracle trying to compile synonym and makes it VALID(But I had the situation that it couldn't compile it and synonym was left INVALID, I compiled it by hand with the command: alter synonym mysynonym compile;)
connected as mari_dba1 and selected "a" table. got your error that object doesn't exists. this happened because gr…