Data access auditing is a surveillance mechanism that watches over access to all sensitive information contained within the database. What are the questions addressed in a perfect data access…

The correct answer is A. Who accessed the data? B. When was the data accessed? D. What was the SQL query that accessed the data? The perfect data access auditing solution would address the following six questions: 1.Who accessed the data? 2.When was the data accessed? 3.Which computer program or client software was used to access the data? 4.From what location on the network was the data accessed? 5.What…

Database & Application Auditing

Question

Data access auditing is a surveillance mechanism that watches over access to all sensitive information contained within the database. What are the questions addressed in a perfect data access auditing solution?

Options

AWho accessed the data?
BWhen was the data accessed?
CFor whom was the data accessed?
DWhat was the SQL query that accessed the data?

How the community answered

(35 responses)

A
77% (27)
C
23% (8)

Explanation

The perfect data access auditing solution would address the following six questions: 1.Who accessed the data? 2.When was the data accessed? 3.Which computer program or client software was used to access the data? 4.From what location on the network was the data accessed? 5.What was the SQL query that accessed the data? 6.Was access to the data successfully done; and if so, how many rows of data were retrieved? Answer: C is incorrect. In the perfect data access auditing solution, it cannot be determined for whom the data is being accessed. Only the person accessing the data can be identified.

Topics

#data access auditing#SQL query logging#database surveillance#audit accountability

Community Discussion

No community discussion yet for this question.

Full GSNA Practice