Hello, I can not execute consecutive GRANT statement. I have to execute a single GRANT a time.
GRANT EXECUTE, SELECT, STATISTICS, SHOW ON "DBC" TO "DBADMIN" WITH GRANT OPTION; GRANT MONRESOURCE, MONSESSION, ABORTSESSION, SETSESSRATE, SETRESRATE, REPLCONTROL, CREATE PROFILE, CREATE ROLE, DROP PROFILE, DROP ROLE TO "DBADMIN" WITH GRANT OPTION;
If I copy these two statements to the query window in teradata assistant, I got:
3932 Only an ET or null statement is legal after a DDL Statement.
But if I execute them one by one, it works well.
GRANT is not a DDL statement but a DCL statement. Could any body tell me the reason why?