0 votes
in PL/SQL by
Can Triggers Reference Other Tables Through A Role?

1 Answer

0 votes
by
Triggers may require referencing other tables while triggering an event. Therefore, privileges required to reference other tables must be granted directly to the owner of the trigger, as the trigger cannot reference other user tables through roles.

For example, consider a trigger, which is used for any audit table. To insert a row in the audit table, the owner of the trigger must have the insert privilege on that audit table.

Related questions

0 votes
asked Mar 15, 2021 in PL/SQL by Robindeniel
0 votes
asked Mar 11, 2021 in PL/SQL by Robindeniel
...