The Utility of Logon Triggers by Jeff Maresh
In Oracle RDBMS release 8.1.5, a series of database level triggers were introduced. The triggering events included database startup and shutdown, user logon and logoff, and server errors. These triggers were greeted with much fanfare, but largely faded into obscurity once the novelty faded and other new features took center stage. While they are not as prominent as many other new features that that have been released since then, they certainly solve some of today's pressing problems better than other technical solutions.
This paper illustrates some practical applications for database level logon triggers. This type of trigger fires after users logon to the database. The examples were run using Oracle RDBMS Version 10.2, but they will compile and run without modifications on Versions 9.0 and later.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Jeff Maresh
- Item #: Paper0019
