TEC 5363 Database Security

Syllabus
Schedule
Reading
Discussion
Project
Test
Resource
Tip

Discussions for Week 12

Please follow the rules for discussion, which are available at the course policy page. Your discussion will be graded according to the policy.

 

Discussion Topic:

This week, we start discussion application data auditing. One of the major tools for application data auditing is database triggers. Understanding on how to use the triggers can give you a lot of ability to customerize your own auditing activities.

  1. What is a trigger in a database?
  2. If you want to monitor the activities on CUSTOMER table, can you write a pseudo code for a trigger? In a simplistic term, pseudo code tells the logic flow in plain English.

 

When you are ready, please click Discussion Board to login.