Toad World® Forums

Need help on query to GRANT Permissions to a table

Hi Experts,

I created a table in CUSTOM Schema (Say table name as XYZ). Then I created SYNONYM to it in APPS Schema. Now I want to GRANT Permissions to this table to APPS Schema from Apps Schema itself (We don’t have access to CUSTOM Schema. So we have to do from APPS only). When I run the below query from APPS, it is not working. Can anyone please let me know how to achieve this?

EXEC CUSTOM.APPS_DDL.APPS_DDL(‘GRANT ALL ON CUSTOM.XYZ TO APPS WITH GRANT OPTION’);

Thanks in Advance,

Srivathsava

I am a little confused. How did you create the XYZ table in CUSTOM if you do not have access to CUSTOM?