Suppose The Trig_1 Trigger On The Tab_1 Table Exists In The Schema A,

1.	Suppose The Trig_1 Trigger On The Tab_1 Table Exists In The Schema A, And The Schema B Has Privilege To Access The Tab_1 Table. What Additional Privilege Is Required By Schema B To Be Able To Execute The Trig_1 Trigger?
Answer» No ADDITIONAL privilege is required to execute the TRIGGER as the schema B already has ACCESS privilege to the TRIGGERED table, TAB_1. No additional privilege is required to execute the trigger as the schema B already has access privilege to the triggered table, TAB_1.

Suppose The Trig_1 Trigger On The Tab_1 Table Exists In The Schema A, And The Schema B Has Privilege To Access The Tab_1 Table. What Additional Privilege Is Required By Schema B To Be Able To Execute The Trig_1 Trigger?

Answer»

No ADDITIONAL privilege is required to execute the TRIGGER as the schema B already has ACCESS privilege to the TRIGGERED table, TAB_1.

No additional privilege is required to execute the trigger as the schema B already has access privilege to the triggered table, TAB_1.