Hi, everyone! Happy new year! I am writing a SP in oracle using TOAD, I am able to access the table which is synonym in SQL editor, but have problem to access it in stored procedure, the system told me "the table/view is not existed", how can I fix it? Thanks
Is it a public synonym. If it is then there are also grants which need to be created for the non-owner user to use this table. Even though the table is public the non-owner user needs to have select grants to it to read it. Hope that helps. Mark
Mark, thanks! Actually I have solved the problem to create another synonym specific for that non-owner user and grant the select right to the same user. The previous synonym maybe a public one as you say, but I have no idea why I can select the same table in SQL editor of TOAD with and unable to access it in SP. Raymond
It sure was nice of your sister to lend us her car. Let's show our appreciation by sharing this tiny ad:
