GRANT Syntax (Role Form) - Database Engine 20 - Teradata Vantage

GRANT role_name [,...]
  TO { user_name | role_name } [,...]
  [ WITH ADMIN OPTION ] [;]

Syntax Elements

role_name

One or more comma-separated names of roles to grant to specified users or other roles.

The system ignores duplicate role names.

TO

user_name

role_name

The names of role grantees.

You can specify a maximum of 25 names per GRANT request.

Grantees can be users or roles; however, a role cannot be granted to itself or to PUBLIC.

GRANT does not produce an error if a specified role is already granted to a grantee.

WITH ADMIN OPTION

The role grantees have the privilege to use DROP ROLE, GRANT, and REVOKE statements to administer the specified roles.

To change a privilege previously granted WITH ADMIN OPTION, a GRANT statement must include WITH ADMIN OPTION.