A user needs to create a trigger that will update table T2 whenever a row is added to table T1.
Assuming the user has all appropriate privileges for table T2, which privilege is required on table
T1 to create the trigger?
A.
REFERENCES
B.
SELECT
C.
UPDATE
D.
ALTER
D
0
0
CREATE TRIGGER statement
The CREATE TRIGGER statement defines a trigger in the database.
Invocation
This statement can be embedded in an application program or issued through the use of dynamic SQL statements. It is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is in effect for the package (SQLSTATE 42509).
Authorization
The privileges held by the authorization ID of the statement must include at least one of the following:
ALTER privilege on the table on which the BEFORE or AFTER trigger is defined
CONTROL privilege on the view on which the INSTEAD OF TRIGGER is defined
Owner of the view on which the INSTEAD OF trigger is defined
ALTERIN privilege on the schema of the table or view on which the trigger is defined
DBADM authority
0
0