REVOKE [ ADMIN OPTION FOR ] role_name [,...]
{ TO | FROM } { user_name | role_name } [,...] [;]
Syntax Elements
- 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.