- ALL [PRIVILEGES]
- Specifies that the specified user is to receive all privileges that can be granted on the specified object.
- NONTEMPORAL
- Specifies that the user can use the NONTEMPORAL prefix to perform nontemporal operations on transaction-time and bitemporal tables contained in database_name or user_name, on table_name, or on view_name.
- privilege
- Specifies a privilege other than NONTEMPORAL.
For details, see Teradata Vantage™ - SQL Data Control Language, B035-1149.
- ALL BUT
- Specifies that the named user is to receive all privileges that can be granted on the specified object except for those specified in the privilege list. As in ALL, only those object privileges owned by the grantor WITH GRANT OPTION are granted.
- ON database_name
- Specifies the name of a database that contains or may contain transaction-time or bitemporal tables or both.
- ON user_name
- Specifies the name of a user that contains or may contain transaction-time tables, bitemporal tables, or both.
- ON table_name
- Specifies the name of a transaction-time or bitemporal table.
- ON view_name
- Specifies the name of an updatable view created on a transaction-time or bitemporal table.
- TO [ALL] username
- Specifies the name of an existing database or user that identifies the recipient.
If you specify ALL, then the object privileges are granted to the named database or user and to every database or user owned by that database or user now and in the future.
- WITH GRANT OPTION
- Specifies that the grantee receives the granted privileges WITH GRANT OPTION.