about: GRANT

Database
Enthusiast

about: GRANT

Hello, I can not execute consecutive GRANT statement. I have to execute a single GRANT a time.

For example:

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?

Thank you!

Best Regards

Charles

Tags (3)