ANSI Compliance - Teradata Database

UPDATE is ANSI SQL:2011-compliant.

The following privilege rules apply to the UPDATE statement.

You must have the UPDATE privilege on the table or columns to be updated.

To update any UDT column, you must also have the UDTUSAGE privilege on that column.

When executing an UPDATE that also requires READ access to an object, you must have the SELECT privilege on the data being accessed.

For example, in the following request, READ access is required by the WHERE condition.

     UPDATE table_1 

     SET column_1 = 1 

     WHERE column_1 < 0;

Similarly, the following request requires READ access because you must read column_1 values from table_1 in order to compute the new values for column_1.

     UPDATE table_1 

     SET field_1 = column_1 + 1;

The following request does not require SELECT privileges:

     UPDATE table_1 

     SET column_3 = 0 ALL;