3523 error will come when the permission/access is denied for the user.
(For example, you tried to perform an action within Teradata for which you are not authorized.)
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.
- 3523 %FSTR does not have %VSTR access to %DBID.%TVMID
Remedy: |
---|
Obtain the necessary access rights. |
You will have to give rights to that DB SELECT WITH GRANT OPTION on the table you are accessing. |