pulumi-azure-kotlin/com.pulumi.azure.mysql.kotlin/FlexibleServerActiveDirectoryAdministratoryArgs

FlexibleServerActiveDirectoryAdministratoryArgs

data class FlexibleServerActiveDirectoryAdministratoryArgs(val identityId: Output<String>? = null, val login: Output<String>? = null, val objectId: Output<String>? = null, val serverId: Output<String>? = null, val tenantId: Output<String>? = null) : ConvertibleToJava<FlexibleServerActiveDirectoryAdministratoryArgs>

Manages an Active Directory administrator on a MySQL Flexible Server

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const current = azure.core.getClientConfig({});
const example = new azure.core.ResourceGroup("example", {
    name: "example-resources",
    location: "West Europe",
});
const exampleUserAssignedIdentity = new azure.authorization.UserAssignedIdentity("example", {
    name: "exampleUAI",
    resourceGroupName: example.name,
    location: example.location,
});
const exampleFlexibleServer = new azure.mysql.FlexibleServer("example", {
    name: "example-mysqlfs",
    resourceGroupName: example.name,
    location: example.location,
    administratorLogin: "_admin_Terraform_892123456789312",
    administratorPassword: "QAZwsx123",
    skuName: "B_Standard_B1ms",
    zone: "2",
    identity: {
        type: "UserAssigned",
        identityIds: [exampleUserAssignedIdentity&#46;id],
    },
});
const exampleFlexibleServerActiveDirectoryAdministratory = new azure.mysql.FlexibleServerActiveDirectoryAdministratory("example", {
    serverId: exampleFlexibleServer.id,
    identityId: exampleUserAssignedIdentity.id,
    login: "sqladmin",
    objectId: current.then(current => current.clientId),
    tenantId: current.then(current => current.tenantId),
});
Content copied to clipboard
import pulumi
import pulumi_azure as azure
current = azure.core.get_client_config()
example = azure.core.ResourceGroup("example",
    name="example-resources",
    location="West Europe")
example_user_assigned_identity = azure.authorization.UserAssignedIdentity("example",
    name="exampleUAI",
    resource_group_name=example.name,
    location=example.location)
example_flexible_server = azure.mysql.FlexibleServer("example",
    name="example-mysqlfs",
    resource_group_name=example.name,
    location=example.location,
    administrator_login="_admin_Terraform_892123456789312",
    administrator_password="QAZwsx123",
    sku_name="B_Standard_B1ms",
    zone="2",
    identity={
        "type": "UserAssigned",
        "identity_ids": [example_user_assigned_identity&#46;id],
    })
example_flexible_server_active_directory_administratory = azure.mysql.FlexibleServerActiveDirectoryAdministratory("example",
    server_id=example_flexible_server.id,
    identity_id=example_user_assigned_identity.id,
    login="sqladmin",
    object_id=current.client_id,
    tenant_id=current.tenant_id)
Content copied to clipboard
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
    var current = Azure.Core.GetClientConfig.Invoke();
    var example = new Azure.Core.ResourceGroup("example", new()
    {
        Name = "example-resources",
        Location = "West Europe",
    });
    var exampleUserAssignedIdentity = new Azure.Authorization.UserAssignedIdentity("example", new()
    {
        Name = "exampleUAI",
        ResourceGroupName = example.Name,
        Location = example.Location,
    });
    var exampleFlexibleServer = new Azure.MySql.FlexibleServer("example", new()
    {
        Name = "example-mysqlfs",
        ResourceGroupName = example.Name,
        Location = example.Location,
        AdministratorLogin = "_admin_Terraform_892123456789312",
        AdministratorPassword = "QAZwsx123",
        SkuName = "B_Standard_B1ms",
        Zone = "2",
        Identity = new Azure.MySql.Inputs.FlexibleServerIdentityArgs
        {
            Type = "UserAssigned",
            IdentityIds = new[]
            {
                exampleUserAssignedIdentity.Id,
            },
        },
    });
    var exampleFlexibleServerActiveDirectoryAdministratory = new Azure.MySql.FlexibleServerActiveDirectoryAdministratory("example", new()
    {
        ServerId = exampleFlexibleServer.Id,
        IdentityId = exampleUserAssignedIdentity.Id,
        Login = "sqladmin",
        ObjectId = current.Apply(getClientConfigResult => getClientConfigResult.ClientId),
        TenantId = current.Apply(getClientConfigResult => getClientConfigResult.TenantId),
    });
});
Content copied to clipboard
package main
import (
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/authorization"
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/mysql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		current, err := core.GetClientConfig(ctx, map[string]interface{}{}, nil)
		if err != nil {
			return err
		}
		example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
			Name:     pulumi.String("example-resources"),
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		exampleUserAssignedIdentity, err := authorization.NewUserAssignedIdentity(ctx, "example", &authorization.UserAssignedIdentityArgs{
			Name:              pulumi.String("exampleUAI"),
			ResourceGroupName: example.Name,
			Location:          example.Location,
		})
		if err != nil {
			return err
		}
		exampleFlexibleServer, err := mysql.NewFlexibleServer(ctx, "example", &mysql.FlexibleServerArgs{
			Name:                  pulumi.String("example-mysqlfs"),
			ResourceGroupName:     example.Name,
			Location:              example.Location,
			AdministratorLogin:    pulumi.String("_admin_Terraform_892123456789312"),
			AdministratorPassword: pulumi.String("QAZwsx123"),
			SkuName:               pulumi.String("B_Standard_B1ms"),
			Zone:                  pulumi.String("2"),
			Identity: &mysql.FlexibleServerIdentityArgs{
				Type: pulumi.String("UserAssigned"),
				IdentityIds: pulumi.StringArray{
					exampleUserAssignedIdentity.ID(),
				},
			},
		})
		if err != nil {
			return err
		}
		_, err = mysql.NewFlexibleServerActiveDirectoryAdministratory(ctx, "example", &mysql.FlexibleServerActiveDirectoryAdministratoryArgs{
			ServerId:   exampleFlexibleServer.ID(),
			IdentityId: exampleUserAssignedIdentity.ID(),
			Login:      pulumi.String("sqladmin"),
			ObjectId:   pulumi.String(current.ClientId),
			TenantId:   pulumi.String(current.TenantId),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.CoreFunctions;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.authorization.UserAssignedIdentity;
import com.pulumi.azure.authorization.UserAssignedIdentityArgs;
import com.pulumi.azure.mysql.FlexibleServer;
import com.pulumi.azure.mysql.FlexibleServerArgs;
import com.pulumi.azure.mysql.inputs.FlexibleServerIdentityArgs;
import com.pulumi.azure.mysql.FlexibleServerActiveDirectoryAdministratory;
import com.pulumi.azure.mysql.FlexibleServerActiveDirectoryAdministratoryArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        final var current = CoreFunctions.getClientConfig(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference);
        var example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("example-resources")
            .location("West Europe")
            .build());
        var exampleUserAssignedIdentity = new UserAssignedIdentity("exampleUserAssignedIdentity", UserAssignedIdentityArgs.builder()
            .name("exampleUAI")
            .resourceGroupName(example.name())
            .location(example.location())
            .build());
        var exampleFlexibleServer = new FlexibleServer("exampleFlexibleServer", FlexibleServerArgs.builder()
            .name("example-mysqlfs")
            .resourceGroupName(example.name())
            .location(example.location())
            .administratorLogin("_admin_Terraform_892123456789312")
            .administratorPassword("QAZwsx123")
            .skuName("B_Standard_B1ms")
            .zone("2")
            .identity(FlexibleServerIdentityArgs.builder()
                .type("UserAssigned")
                .identityIds(exampleUserAssignedIdentity.id())
                .build())
            .build());
        var exampleFlexibleServerActiveDirectoryAdministratory = new FlexibleServerActiveDirectoryAdministratory("exampleFlexibleServerActiveDirectoryAdministratory", FlexibleServerActiveDirectoryAdministratoryArgs.builder()
            .serverId(exampleFlexibleServer.id())
            .identityId(exampleUserAssignedIdentity.id())
            .login("sqladmin")
            .objectId(current.clientId())
            .tenantId(current.tenantId())
            .build());
    }
}
Content copied to clipboard
resources:
  example:
    type: azure:core:ResourceGroup
    properties:
      name: example-resources
      location: West Europe
  exampleFlexibleServer:
    type: azure:mysql:FlexibleServer
    name: example
    properties:
      name: example-mysqlfs
      resourceGroupName: ${example.name}
      location: ${example.location}
      administratorLogin: _admin_Terraform_892123456789312
      administratorPassword: QAZwsx123
      skuName: B_Standard_B1ms
      zone: '2'
      identity:
        type: UserAssigned
        identityIds:
          - ${exampleUserAssignedIdentity.id}
  exampleUserAssignedIdentity:
    type: azure:authorization:UserAssignedIdentity
    name: example
    properties:
      name: exampleUAI
      resourceGroupName: ${example.name}
      location: ${example.location}
  exampleFlexibleServerActiveDirectoryAdministratory:
    type: azure:mysql:FlexibleServerActiveDirectoryAdministratory
    name: example
    properties:
      serverId: ${exampleFlexibleServer.id}
      identityId: ${exampleUserAssignedIdentity.id}
      login: sqladmin
      objectId: ${current.clientId}
      tenantId: ${current.tenantId}
variables:
  current:
    fn::invoke:
      function: azure:core:getClientConfig
      arguments: {}
Content copied to clipboard

API Providers

This resource uses the following Azure API Providers:

  • Microsoft.DBforMySQL: 2023-12-30

Import

A MySQL Flexible Server Active Directory Administrator can be imported using the resource id, e.g.

$ pulumi import azure:mysql/flexibleServerActiveDirectoryAdministratory:FlexibleServerActiveDirectoryAdministratory example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/resourceGroup1/providers/Microsoft.DBforMySQL/flexibleServers/server1/administrators/ActiveDirectory
Content copied to clipboard

Constructors

constructor(identityId: Output<String>? = null, login: Output<String>? = null, objectId: Output<String>? = null, serverId: Output<String>? = null, tenantId: Output<String>? = null)

Properties

Link copied to clipboard
val identityId: Output<String>? = null

The resource ID of the identity used for AAD Authentication.

Link copied to clipboard
val login: Output<String>? = null

The login name of the principal to set as the server administrator

Link copied to clipboard
val objectId: Output<String>? = null

The ID of the principal to set as the server administrator. For a managed identity this should be the Client ID of the identity.

Link copied to clipboard
val serverId: Output<String>? = null

The resource ID of the MySQL Flexible Server. Changing this forces a new resource to be created.

Link copied to clipboard
val tenantId: Output<String>? = null

The Azure Tenant ID.

Functions

Link copied to clipboard
open override fun toJava(): FlexibleServerActiveDirectoryAdministratoryArgs