In this blog, discover how to securely execute SQL scripts in Azure Pipelines using a service principal with minimal permissions. Explore the steps to grant precise access, reducing security risks while ensuring smooth integration with your CI/CD workflows.
Latest posts tagged on "Service Principal"
Generating an Access Token for Azure SQL Database Using Service Principal with Client Secret using PowerShell
This blog post explains the process of generating an access token for Azure SQL Database using a service principal with client secret using PowerShell. It provides a clear, step-by-step guide to creating a service principal, assigning the necessary permissions, installing the Azure PowerShell module, authenticating with the service principal, and obtaining the access token. The instructions are concise and easy to follow, enabling users to authenticate and access Azure SQL Database through PowerShell scripting.
Running a SQL Script from the Azure Pipeline using a Service Principal with Certificate
In this blog post, we will discuss how to securely and reliably execute a SQL script from an Azure Pipeline using a Service Connection with a Client Secret. We will explore the step-by-step process, starting with creating a Service Connection in Azure DevOps, creating a service principal, setting the permissions and finally setting up the Azure Pipeline.
Running a SQL Script from the Azure Pipeline using a Service Principal with Client Secret
In this blog post, we will discuss how to securely and reliably execute a SQL script from an Azure Pipeline using a Service Connection with a Client Secret. We will explore the step-by-step process, starting with creating a Service Connection in Azure DevOps, creating a service principal, setting the permissions and finally setting up the Azure Pipeline.