Authorization
The privileges held by the authorization ID of the statement must include
at least one of the following:
The privileges held by the authorization ID of the statement must include
at least one of the following:
- Each of the following:
- The ALTER privilege on the table or view on which the trigger
is defined,
- The SELECT privilege on the table or view on which the trigger
is defined,
- The SELECT privilege on any table or view referenced in the search-condition in the trigger-action,
- The UPDATE privilege on the table on which the trigger is defined, if
the BEFORE UPDATE trigger contains a SET statement that modifies the NEW correlation
variable,
- The privileges required to execute each triggered-SQL-statement, and
- The system authority *EXECUTE on the library containing the
table or view on which the trigger is defined.
- Administrative authority
In addition, the privileges held by the authorization ID of the statement
must include at least one of the following:
- The following system authorities:
- *USE on the Add Physical File Trigger (ADDPFTRG) command,
- *USE on the Create Program (CRTPGM) command
- Administrative authority
If SQL names are specified, and a user profile exists that has the same
name as the library into which the trigger is created, and the name is different
from the authorization ID of the statement, then the privileges held by the
authorization ID of the statement must include at least one of the following:
- *ALLOBJ and *SECADM special authority
- Administrative authority
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.