ANSI Compliance - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

The upsert form of UPDATE is a Teradata extension to the ANSI SQL:2011 standard.

The following privilege rule applies to both the UPDATE and INSERT portions of this statement:

  • You must have both update and insert privileges on the base table, view, or column set to be updated regardless of which portion of the request is performed.
  • The following privilege rules applies to the UPDATE portion of this statement:

  • You must have the UPDATE privilege on the base table, view, or column set to be updated.
  • To update rows through a view, you must have the UPDATE privilege on the view.
  • Also, the immediate owner of the view (that is, the database in which the view resides) must have the UPDATE privilege on the underlying object (view or base table).
  • The following privilege rules apply to the INSERT portion of this statement:

  • You must have the INSERT privilege on the referenced table.
  • To insert rows into a table through a view, you must have the INSERT privilege on the view.
  • Also, the immediate owner of the view (that is, the database in which the view resides) must have the INSERT privilege on the underlying object (view or base table).