Multiple choice technology databases

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?

  1. Table

  2. Columns

  3. Table and Alias

  4. Columns and Alias
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When using an alias to update a table, the user must have UPDATE privileges on the underlying Table itself, not on the alias or individual columns. DB2 checks privileges on the base object that the alias references. The alias is simply an alternative name for the table and doesn't require separate privileges.

Keep practicing — related questions