Business and technology qualifications, Levels 3-6, in Brussels. Explore qualifications
Portal login
Level 6 Diploma in Information Technology

Database Access Control and Granular Security

IT603 · Advanced Database Management Systems — Week 7 of 16

CourseIT603
Week7 of 16
SemesterI
TutorOnline in the course chat

This week’s topics

Database Access Control and Granular Security

  1. Role-based access control
  2. Table and column permissions
  3. Row-level security policies
  4. Dynamic data masking
  5. Access Control (ITS335, L08, Y15)

What you will be able to do

  • 3.3 Apply table and field-level security to the database.

Activity

Start with this week’s video, then: Seminar, guided reading and a short written task: apply table and field-level security to the database.

Study materials

Videos

  • Access Control (ITS335, L08, Y15) · YouTube · Steven Gordon · 64 min · for registered students

Further resources

  • CyBOK: Authentication, Authorisation and Accountability Knowledge Area · PDF · Cybok, textbook chapter; 43 pages · for registered students
  • Security Engineering (3rd ed.), ch. 6: Access Control · PDF · Other, textbook chapter; pp. 207–241 · for registered students
  • Operating Systems: Three Easy Pieces (v1.10), ch. 55: Access Control · PDF · Other, textbook chapter; 18 pages · for registered students
Materials marked “for registered students” open in the student portal, which is set up as soon as you receive final acceptance.
Week 6Midterm
Course chat

Admitted students ask questions on this week’s page in the student portal: an AI assistant trained on the course answers first, and during the course’s timetabled classes Connect to your tutor brings your tutor into the chat, who may start a call if needed.

Open this week in the portal
Course plan
  • Week 1: Relational Theory and Normalisation
  • Week 2: Database Modelling Languages
  • Week 3: Database Engine Architecture and Platform Selection
  • Week 4: Logical Modelling and Normalisation Practice
  • Week 5: Physical Database Design and Build
  • Week 6: Advanced Querying and Data Extraction
  • Week 7: Database Access Control and Granular Security
  • Midterm: Midterm evaluation
  • Week 9: Database Threat Landscape and Risk Evaluation
  • Week 10: Database Functional and Performance Testing
  • Week 11: Database Administration and Enterprise Resilience
  • Week 12: Applying Advanced Database Management Systems in practice: …
  • Week 13: Assignment workshop: research, planning and referencing
  • Week 14: Assignment workshop: drafting, feedback and improvement
  • Week 15: Review and coursework completion
  • Final: Final assessment and submission
Back to the course
Scroll