Database Roles and Permissions Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Authorization

What you'll be asked

  1. Which principle should be followed when assigning database permissions to users?
  2. What is the primary benefit of using database roles instead of assigning permissions directly to individual user accounts?
  3. A developer needs to read data from a specific table but should not be able to modify it. Which SQL command is most appropriate?
  4. When auditing database security, you discover a user account has 'GRANT OPTION' privileges. What is the primary security risk associated with this?
  5. You are implementing a security policy where a 'Reporting' role must access data from a 'Sales' schema, but the 'Sales' schema owner wants to ensure the 'Reporting' role cannot access new tables added to the schema in the future. How should you handle this?

Answers and explanations come after you submit.