Triggering Security Features of Oracle
Published: 2018
Author(s) Name: Ankur N. Shah |
Author(s) Affiliation: Assistant Professor, CE Department, Babaria Institute of Technology, Vadodara, Gujarat, India.
Locked
Subscribed
Available for All
Abstract
Database trigger is a PL/SQL block that is executed on an event in the database. The event is related to a particular data manipulation of a table such as inserting, deleting or updating a row of a table [8]. Triggers are automatically fired when condition written for trigger is matched. Thus it provides security to database by avoiding harmful operations on database. The triggers are also cascading, so trigger can be called by another trigger. There are also various types of triggers available. Even there are various advantages of using trigger, the excessive use of triggers can result in complex interdependences, which may be difficult to maintain in a large application. So it advisable to used trigger when they are really needed.
Keywords: Procedure, Security, Trigger.
View PDF