Revocable Privileges - Teradata Vantage - Analytics Database
SQL Data Control Language
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-03-29
- dita:mapPath
- sgu1628111251052.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- dvv1472243528022
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Implicit privileges cannot be revoked.
- Revoking the GRANT OPTION for a privilege from a user immediately revokes the privilege of that user to grant that privilege, but does not affect privileges that have already been granted by that user to others.
- The user who revokes a privilege from another need not be the grantor of that privilege. If a user receives the same privilege from two or more grantors, any grantor with the necessary privileges can revoke that privilege from the user and from other grantees.
- If a privilege that was granted to ALL user_name is revoked from user_name , then the privilege is not granted automatically to future users owned by user_name.