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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.