REVOKE Syntax Elements (Role Form)

REVOKE 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

ADMIN OPTION FOR: Indicates that the roles and users who were granted this role lose the privilege to use GRANT, REVOKE, and DROP ROLE statements to administer the specified role.; If you do not specify ADMIN OPTION FOR in the REVOKE request, the system revokes the specified role from the roles or users to which it was granted.
role_name: One or more comma-separated names of roles that are being revoked.; You can specify a maximum of 25 names per REVOKE request.; The system ignores duplicate role names.
TO
FROM
user_name
role_name: The names of roles or users or both from which the role or the ability to administer the role is being revoked.; The system does not return errors for users or roles that were not previously granted the specified role.; The TO keyword is a Teradata extension to ANSI/ISO SQL:2011.