PrepAway - Latest Free Exam Questions & Answers

which privilege is required on table T1 to create the trigger?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
REFERENCES

B.
SELECT

C.
UPDATE

D.
ALTER

2 Comments on “which privilege is required on table T1 to create the trigger?

  1. Chow, Kenneth KY says:

    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

Leave a Reply