PROMPT Creating Public Synonym XXXX
CREATE PUBLIC SYNONYM XXXX
 FOR YYYY.XXXX;

PROMPT Granting Permissions to role ROLE_ADMIN
GRANT EXECUTE ON YYYY.ZZZZ
 TO ROLE_ADMIN;

PROMPT Granting Permissions to role ROLE_USER
GRANT EXECUTE ON YYYY.AAAA
 TO ROLE_ADMIN;

GRANT SELECT ON YYYY.BBBB
 TO ROLE_ADMIN;

GRANT DELETE,INSERT,SELECT,UPDATE ON YYYY.CCCC
 TO ROLE_ADMIN;

GRANT EXECUTE ON YYYY.DDDD
 TO ROLE_USER;