GRANT Syntax Elements (Role Form)

GRANT Syntax Elements (Role Form) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

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.