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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.