mload error 3524

Tools
Enthusiast

mload error 3524

We have a scheduled Teradata job runs everyday and works fine. Recently, this job failed with error code 3524, the user does not have CREATE TABLE access to database XXX ( our database name). I know that is not correct since it has run a while and nothing has been changed. We rerun the job using the same user after it failed; it ran successfully without any scripts changes. Have you met this problem before? We are on Teradata version 12. Really appreciate your input.

Best Regards
2 REPLIES
Enthusiast

Re: mload error 3524

Check the Grant access option
Enthusiast

Re: mload error 3524

If your script uses SP's or macros, try re-compiling.