Suppose you wish to create an audit trail of changes to the takes relation. a. Define triggers

Question:

Suppose you wish to create an audit trail of changes to the takes relation.

a. Define triggers to create an audit trail, logging the information into a relation called, for example, takes trail. The logged information should include the user-id (assume a function user id() provides this information) and a timestamp, in addition to old and new values. Youmust also provides the schema of the takes trail relation.

b. Can the preceding implementation guarantee that updates made by a malicious database administrator (or someone who manages to get the administrator’s password) will be in the audit trail? Explain your answer.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Question Posted: