Trusted by millions of Kenyans
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Describe database security.

Describe database security.

Answers


Kavungya
As database practitioners, we must provide a means of preventing unauthorized use of data in a database. Three areas are considered
1. Access Control: Who should be allowed access to which databases? This is typically enforced using system level accounts with passwords.
2. Authorization: for the purposes of:
- Reading Data - Such as reading another employee's salary (using a SELECT statement)
- Writing Data - Such as changing a value in a database (using UPDATE or DELETE)
3. Statistical Information: Enforcing who should be allowed access to information derived from underlying databases (Census example).
Kavungya answered the question on May 10, 2019 at 12:32

Answer Attachments

Exams With Marking Schemes

Related Questions