Authorization

The privileges held by the authorization ID of the statement must include at least one of the following:

If the search-condition in a Searched DELETE contains a reference to a column of the table or view, then the privileges held by the authorization ID of the statement must also include one of the following:

If search-condition includes a subquery, the privileges held by the authorization ID of the statement must also include at least one of the following:

For information on the system authorities corresponding to SQL privileges, see Corresponding System Authorities When Checking Privileges to a Table or View.