SOLVED: Nested roles "WITH GRANT OPTION"

Aster
Tourist

SOLVED: Nested roles "WITH GRANT OPTION"

What is the proper syntax for specifying WITH GRANT OPTION when nesting roles, for instance if you want to have a "super-role" that can give other users grants to a specific set of other roles? From the Teradata Aster Database Administration Student Guide (Version 6.0.2), pg. 8-20:

 

          GRANT role TO username OR rolename [ WITH GRANT OPTION ];

 

But this syntax isn't being accepted for: 

 

          GRANT role_a TO role_b WITH GRANT OPTION;

 

Is this possible in Aster, and if so, what would the correct syntax be?

 

 

UPDATE 08/16: Correct syntax is:

 

          GRANT role_a TO role_b WITH ADMIN OPTION;

 

So I guess it's "with grant option" for object-specific privileges and "with admin option" for role/group membership?