The GRANT statement has the following variations:
| This Statement... | Grants or Revokes... |
|---|---|
| GRANT/REVOKE (SQL Form) | database privileges to a user or role. |
| GRANT/REVOKE (Monitor Form) | monitoring privileges for a user or role. See Teradata Vantage™ - SQL Data Control Language, B035-1149. |
| GRANT LOGON/REVOKE LOGON | logon privileges to a user. For usage, see About Logon Privileges. |
| GRANT ROLE/REVOKE ROLE | membership in a role for one or more users or other roles. |
| GRANT CONNECT THROUGH/REVOKE CONNECT THROUGH |
|
For GRANT and REVOKE statement syntax and options, see Teradata Vantage™ - SQL Data Control Language, B035-1149.