Book Image

Security-Driven Software Development

By : Aspen Olmsted
Book Image

Security-Driven Software Development

By: Aspen Olmsted

Overview of this book

Extend your software development skills to integrate security into every aspect of your projects. Perfect for any programmer or developer working on mission-critical applications, this hands-on guide helps you adopt secure software development practices. Explore core concepts like security specifi cation, modeling, and threat mitigation with the iterative approach of this book that allows you to trace security requirements through each phase of software development. You won’t stop at the basics; you’ll delve into multiple-layer att acks and develop the mindset to prevent them. Through an example application project involving an entertainment ticketing software system, you’ll look at high-profi le security incidents that have aff ected popular music stars and performers. Drawing from the author’s decades of experience building secure applications in this domain, this book off ers comprehensive techniques where problem-solving meets practicality for secure development. By the end of this book, you’ll have gained the expertise to systematically secure software projects, from crafting robust security specifi cations to adeptly mitigating multifaceted threats, ensuring your applications stand resilient in the face of evolving cybersecurity challenges.
Table of Contents (20 chapters)
Free Chapter
1
Part 1: Modeling a Secure Application
8
Part 2: Mitigating Risks in Implementation
13
Part 3: Security Validation

RBAC security in DBMS

Role-Based Access Control (RBAC) is a widely used access control mechanism in database systems. RBAC provides a flexible and scalable approach to managing access permissions by associating users with roles and defining the privileges associated with each role. We introduced access control back in Chapter 7 when we discussed authentication and authorization. Let’s explore RBAC in the context of database systems.

The key concepts of RBAC in database systems are the following:

  • Roles:
    • Definition: Roles represent a set of permissions or privileges
    • Purpose: Users are assigned roles, each with specific access rights
    • Example: Roles can be defined for different job functions such as “Admin,” “Manager,” or “Employee”
  • Users:
    • Definition: Users are individuals or entities granted access to the database
    • Association: Users are assigned to one or more roles based on their responsibilities
    • Example: A user with the...