Authorization

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.