teradata 3253 error

 *** Failure 3523 An owner referenced by user does not have SELECT WITH GRANT OPTION access to BIC.OFR_MAIN_ASSET_HIST_A.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.

teradata manual:

3523 %FSTR does not have %VSTR access to %DBID.%TVMID.

Explanation: The user does not have the proper access rights to execute this request, or the owner of the requested view or macro does not have the proper access rights to underlying tables.

Generated By: SQL modules.

For Whom: End User.

Remedy: Obtain the necessary access rights.

原因,对于通过视图访问的表, 视图需要具有with grant option；

GRANT SELECT ON TABLE_DATABASE TO VIEW_DATABASE WITH GRANT OPTION;

即：GRANT SELECT ON BIC TO BICVIEW_A WITH GRANT OPTION;