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,