Database triggers are utilized to record logins by users

Assignment Help Database Management System

Reference no: EM1347745

Q1) Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

CREATE OR REPLACE TRIGGER logonaudit AFTER LOGON ON DATABASE

BEGIN
insert into system.login_history values(user, sysdate);
END;

What would be the advantages and disadvantages of using a trigger as opposed to auditing with the statement below?

Reference no: EM1347745

Questions Cloud

Design a benefits election system : Individual project for this course is in form of Service Request from Huffman Trucking. It is essential for student to access Service Request: SR-ht-001. Design a Benefits Election System.

Differences in flexible and static budget : You're in the job interview and your possible employer asks you to explain the differences between the flexible and static budget and to explain which you would recommend for the small business and why. How would you respond to this potential empl..

Explain is there a relationship among the age : Explain is there a relationship among the age of an unemployed individual and the number of weeks of unemployment.

Us budget deficits foreign financed : Describe the relationship between the trade deficit and financing of the U.S. budget deficit by foreign countries. Is this the potentially dangerous situation?

Database triggers are utilized to record logins by users : Several times, database triggers are utilized to record logins by users. Here is the example of login trigger that inserts row into table every time a user connects.

Determination of roi : Compass, corporation purchased a new machine and incurred $9,000 of interest, installation, and overhead expenses that should have been capitalized. Determine the ROI, for 2010, suppose that the $9,000 had been capitalized.

Compute direct materials production budget : Hannon Company has 1,600 pounds of raw materials in its December 31, 2011, ending inventory. Needed production for January and February of 2012 are 4,000 and 5,500 units, respectively.

Explain how much in excess reserves does abc holds : Suppose the T-account for ABC bank is as follows: assets: reserves($150000), loans(250,000)and deposits $400,000.if the fed requires banks to hold a 10 percent of deposits as reserves explain how much in excess reserves does ABC holds.

Security by implementing database auditing : You are a DBA for corporation's databases. The management has decided to increase security by applying database auditing yet they are unspecific what actions to audit.

User Account

All Pages