0 votes
in PL/SQL by
Explain what are The System Privileges That Are Required By A Schema Owner (user) To Create A Trigger On A Table?

1 Answer

0 votes
by

A user must be able to alter a table to create a trigger on the table. The user must own the table and either have the ALTER TABLE privilege on that table or have the ALTER ANY TABLE system privilege. In addition, the user must have the CREATE TRIGGER system privilege. User should have the CREATE ANY TRIGGER system privilege to be able to create triggers in any other user account or schema.

A database-level event trigger can be created if the user has the ADMINISTER DATABASE TRIGGER system privilege.

Related questions

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