Syntax - Advanced SQL Engine - Teradata Database

GRANT privilege_spec ON item TO
  { user_spec [,...] | PUBLIC }
  [ WITH GRANT OPTION ] [;]

privilege_spec

{ ALL [ PRIVILEGES ] |
  [ ALL BUT] { NONTEMPORAL | privilege } [,...]
}

item

{ database_name |
  user_name |
  [ database_name. | user_name. ] { table_name | view_name }
}

user_spec

[ALL] user_name

ALL [PRIVILEGES]

Specifies that the specified user is to receive all privileges that can be granted on the specified object.

GRANT ALL includes the NONTEMPORAL privilege if the InclNTforGrntOrRevokAll field of the DBS Control utility is set to TRUE. Otherwise, GRANT ALL excludes the NONTEMPORAL privilege.

All of the privileges, including the NONTEMPORAL privilege, that the grantor has on the object are granted if a user has them with WITH GRANT OPTION.

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 "GRANT" in 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.