The privileges held by the authorization ID of the statement must include at least one of the following:
To define a foreign key, the privileges held by the authorization ID of the statement must include at least one of the following on the parent table:
If a select-statement is specified, the privileges held by the authorization ID of the statement must include at least one of the following on the tables or views specified in these clauses:
If a distinct type is referenced, the privileges held by the authorization ID of the statement must 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 and Corresponding System Authorities When Checking Privileges to a Distinct Type.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.