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?