REVOKE Syntax Elements (Role Form) - Teradata VantageCloud Lake
Lake - Working with SQL
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata VantageCloud Lake
- Release Number
- Published
- February 2025
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-21
- dita:mapPath
- jbe1714339405530.ditamap
- dita:ditavalPath
- pny1626732985837.ditaval
- dita:id
- jbe1714339405530
- 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.