--------------------------- Dbms_Output Begin --------------------------- 
No permission to grant select on V_APPSUMMARYINFO to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_AVR_ESCALATED_EXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_AVR_EXCEPTIONS_4_OWNR_IN_GRP to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_EXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_NEWEXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_OPENEXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_OPENIGNOREDEXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_OPENINCIDENTEXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
No permission to grant select on V_OPENWORKINGEXCEPTIONS to avdwuser 
ORA-01720: grant option does not exist for 'SYS.DBMS_LOB' 
--------------------------- Dbms_Output End ---------------------------

GRANT EXECUTE ON SYS.DBMS_LOB TO AVDWUSER; 
or 
GRANT EXECUTE ON SYS.DBMS_LOB TO PUBLIC;