All Forums Database
charleshugo 5 posts Joined 02/14
11 Nov 2014
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
 
 
 

You must sign in to leave a comment.