You're reading from Microsoft Azure Security Technologies Certification and Beyond Gain practical skills to secure your Azure environment and pass the AZ-500 exam

Product type Paperback

Published in Nov 2021

Publisher Packt

ISBN-13 9781800562653

Length 526 pages

Edition 1st Edition

Tools

Azure

Concepts

Cybersecurity

Author (1):

David Okeyode

View More author details

Table of Contents (19) Chapters

Preface

1. Section 1: Implement Identity and Access Security for Azure

2. Chapter 1: Introduction to Azure Security FREE CHAPTER

3. Chapter 2: Understanding Azure AD

4. Chapter 3: Azure AD Hybrid Identity

5. Chapter 4: Azure AD Identity Security

6. Chapter 5: Azure AD Identity Governance

7. Section 2: Implement Azure Platform Protection

8. Chapter 6: Implementing Perimeter Security

9. Chapter 7: Implementing Network Security

10. Chapter 8: Implementing Host Security

11. Chapter 9: Implementing Container Security

12. Section 3: Secure Storage, Applications, and Data

13. Chapter 10: Implementing Storage Security

14. Chapter 11: Implementing Database Security

15. Chapter 12: Implementing Secrets, Keys, and Certificate Management with Key Vault

16. Chapter 13: Azure Cloud Governance and Security Operations

17. Assessments

18. Other Books You May Enjoy

Protecting Azure SQL against unauthorized user access

Preventing unauthorized network connections may be the first layer of security for Azure SQL databases but clients still need to be authenticated and authorized before they can gain access. Authentication validates the identity of the client that is requesting access while authorization validates the operations that an identity can perform in a SQL database. Azure SQL Database supports two types of authentication: SQL authentication and Azure Active Directory (Azure AD) authentication.

SQL authentication uses a username and password that is stored in the master database (for server-wide access) or individual databases. When a new SQL logical server is created in Azure, we need to specify a local server admin credential. This credential is referred to as the server admin account. This account can authenticate to any database on that server as the database owner. We can use the initial server admin account to create additional...