Attempting to use AD_ZD.GRANT_PRIVS to add a role to a user account. $ sqlplus apps SQL> EXEC ad_zd

HERE IS WHAT WORKS:
- AD_ZD.GRANT_PRIVS to grant objects to schemas
- AD_ZD.GRANT_PRIVS to grant objects to roles

HERE IS WHAT FAILS:
- AD_ZD.GRANT_PRIVS to grant roles to schemas

He would like to create a role (using APPS) which will use either the ZX tables, ZX views, or APPS synonyms.

The new role XXFIN_EBTAX_USER has select on the following views:
zx_lines#
zx_lines_det_factors#
zx_rec_nrec_dist#

Each view has the necessary APPS WITH GRANT OPTION enabled.

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE, DEBUG ON ZX.ZX_LINES# TO APPS WITH GRANT OPTION;