(a) In a database system, the owner of the created table has the sole rights to...

 

Transcribed Image Text:

(a) In a database system, the owner of the created table has the sole rights to perform operations on that table and he should be cautious to consider the privacy impacts of broadcasting or granting access to sensitive information. Discuss how database privilege can be achieved by granting access and defining roles. (6 marks) (b) Inference attack is crucial to database even if identifying information is removed or masked out. It may still be possible to use the database in conjunction with additional information available to the attacker to learn more about the underlying data. Answer the following questions pertaining to inference attack. (1) Compare and provide TWO characteristics to differentiate between Direct and Indirect attack. (6 marks) (ii) By using figure below, provide THREE methods with elaboration that can be used to protect inference attacks on databases. (9 marks) ID 1001 1002 1003 Name Alice Benny Charles Department H.R. Security Sales Salary 2000 1000 4000 (a) In a database system, the owner of the created table has the sole rights to perform operations on that table and he should be cautious to consider the privacy impacts of broadcasting or granting access to sensitive information. Discuss how database privilege can be achieved by granting access and defining roles. (6 marks) (b) Inference attack is crucial to database even if identifying information is removed or masked out. It may still be possible to use the database in conjunction with additional information available to the attacker to learn more about the underlying data. Answer the following questions pertaining to inference attack. (1) Compare and provide TWO characteristics to differentiate between Direct and Indirect attack. (6 marks) (ii) By using figure below, provide THREE methods with elaboration that can be used to protect inference attacks on databases. (9 marks) ID 1001 1002 1003 Name Alice Benny Charles Department H.R. Security Sales Salary 2000 1000 4000