Docs Packages
  1. Pulumi Registry
  2. Azure Native
  3. API Docs
  4. sql
  5. ManagedInstanceAdministrator
azure-native logo
Azure Native v1.102.0, May 2 23

azure-native.sql.ManagedInstanceAdministrator

Explore with Pulumi AI

An Azure SQL managed instance administrator. API Version: 2020-11-01-preview.

Example Usage

Create administrator of managed instance

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var managedInstanceAdministrator = new AzureNative.Sql.ManagedInstanceAdministrator("managedInstanceAdministrator", new()
    {
        AdministratorName = "ActiveDirectory",
        AdministratorType = "ActiveDirectory",
        Login = "bob@contoso.com",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        Sid = "44444444-3333-2222-1111-000000000000",
        TenantId = "55555555-4444-3333-2222-111111111111",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedInstanceAdministrator(ctx, "managedInstanceAdministrator", &sql.ManagedInstanceAdministratorArgs{
			AdministratorName:   pulumi.String("ActiveDirectory"),
			AdministratorType:   pulumi.String("ActiveDirectory"),
			Login:               pulumi.String("bob@contoso.com"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
			Sid:                 pulumi.String("44444444-3333-2222-1111-000000000000"),
			TenantId:            pulumi.String("55555555-4444-3333-2222-111111111111"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ManagedInstanceAdministrator;
import com.pulumi.azurenative.sql.ManagedInstanceAdministratorArgs;
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) {
        var managedInstanceAdministrator = new ManagedInstanceAdministrator("managedInstanceAdministrator", ManagedInstanceAdministratorArgs.builder()        
            .administratorName("ActiveDirectory")
            .administratorType("ActiveDirectory")
            .login("bob@contoso.com")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .sid("44444444-3333-2222-1111-000000000000")
            .tenantId("55555555-4444-3333-2222-111111111111")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

managed_instance_administrator = azure_native.sql.ManagedInstanceAdministrator("managedInstanceAdministrator",
    administrator_name="ActiveDirectory",
    administrator_type="ActiveDirectory",
    login="bob@contoso.com",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    sid="44444444-3333-2222-1111-000000000000",
    tenant_id="55555555-4444-3333-2222-111111111111")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedInstanceAdministrator = new azure_native.sql.ManagedInstanceAdministrator("managedInstanceAdministrator", {
    administratorName: "ActiveDirectory",
    administratorType: "ActiveDirectory",
    login: "bob@contoso.com",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    sid: "44444444-3333-2222-1111-000000000000",
    tenantId: "55555555-4444-3333-2222-111111111111",
});

resources:
  managedInstanceAdministrator:
    type: azure-native:sql:ManagedInstanceAdministrator
    properties:
      administratorName: ActiveDirectory
      administratorType: ActiveDirectory
      login: bob@contoso.com
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      sid: 44444444-3333-2222-1111-000000000000
      tenantId: 55555555-4444-3333-2222-111111111111

Update administrator of managed instance

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var managedInstanceAdministrator = new AzureNative.Sql.ManagedInstanceAdministrator("managedInstanceAdministrator", new()
    {
        AdministratorName = "ActiveDirectory",
        AdministratorType = "ActiveDirectory",
        Login = "bob@contoso.com",
        ManagedInstanceName = "managedInstance",
        ResourceGroupName = "Default-SQL-SouthEastAsia",
        Sid = "44444444-3333-2222-1111-000000000000",
        TenantId = "55555555-4444-3333-2222-111111111111",
    });

});

package main

import (
	sql "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedInstanceAdministrator(ctx, "managedInstanceAdministrator", &sql.ManagedInstanceAdministratorArgs{
			AdministratorName:   pulumi.String("ActiveDirectory"),
			AdministratorType:   pulumi.String("ActiveDirectory"),
			Login:               pulumi.String("bob@contoso.com"),
			ManagedInstanceName: pulumi.String("managedInstance"),
			ResourceGroupName:   pulumi.String("Default-SQL-SouthEastAsia"),
			Sid:                 pulumi.String("44444444-3333-2222-1111-000000000000"),
			TenantId:            pulumi.String("55555555-4444-3333-2222-111111111111"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ManagedInstanceAdministrator;
import com.pulumi.azurenative.sql.ManagedInstanceAdministratorArgs;
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) {
        var managedInstanceAdministrator = new ManagedInstanceAdministrator("managedInstanceAdministrator", ManagedInstanceAdministratorArgs.builder()        
            .administratorName("ActiveDirectory")
            .administratorType("ActiveDirectory")
            .login("bob@contoso.com")
            .managedInstanceName("managedInstance")
            .resourceGroupName("Default-SQL-SouthEastAsia")
            .sid("44444444-3333-2222-1111-000000000000")
            .tenantId("55555555-4444-3333-2222-111111111111")
            .build());

    }
}

import pulumi
import pulumi_azure_native as azure_native

managed_instance_administrator = azure_native.sql.ManagedInstanceAdministrator("managedInstanceAdministrator",
    administrator_name="ActiveDirectory",
    administrator_type="ActiveDirectory",
    login="bob@contoso.com",
    managed_instance_name="managedInstance",
    resource_group_name="Default-SQL-SouthEastAsia",
    sid="44444444-3333-2222-1111-000000000000",
    tenant_id="55555555-4444-3333-2222-111111111111")

import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedInstanceAdministrator = new azure_native.sql.ManagedInstanceAdministrator("managedInstanceAdministrator", {
    administratorName: "ActiveDirectory",
    administratorType: "ActiveDirectory",
    login: "bob@contoso.com",
    managedInstanceName: "managedInstance",
    resourceGroupName: "Default-SQL-SouthEastAsia",
    sid: "44444444-3333-2222-1111-000000000000",
    tenantId: "55555555-4444-3333-2222-111111111111",
});

resources:
  managedInstanceAdministrator:
    type: azure-native:sql:ManagedInstanceAdministrator
    properties:
      administratorName: ActiveDirectory
      administratorType: ActiveDirectory
      login: bob@contoso.com
      managedInstanceName: managedInstance
      resourceGroupName: Default-SQL-SouthEastAsia
      sid: 44444444-3333-2222-1111-000000000000
      tenantId: 55555555-4444-3333-2222-111111111111

Create ManagedInstanceAdministrator Resource

new ManagedInstanceAdministrator(name: string, args: ManagedInstanceAdministratorArgs, opts?: CustomResourceOptions);
@overload
def ManagedInstanceAdministrator(resource_name: str,
                                 opts: Optional[ResourceOptions] = None,
                                 administrator_name: Optional[str] = None,
                                 administrator_type: Optional[Union[str, ManagedInstanceAdministratorType]] = None,
                                 login: Optional[str] = None,
                                 managed_instance_name: Optional[str] = None,
                                 resource_group_name: Optional[str] = None,
                                 sid: Optional[str] = None,
                                 tenant_id: Optional[str] = None)
@overload
def ManagedInstanceAdministrator(resource_name: str,
                                 args: ManagedInstanceAdministratorArgs,
                                 opts: Optional[ResourceOptions] = None)
func NewManagedInstanceAdministrator(ctx *Context, name string, args ManagedInstanceAdministratorArgs, opts ...ResourceOption) (*ManagedInstanceAdministrator, error)
public ManagedInstanceAdministrator(string name, ManagedInstanceAdministratorArgs args, CustomResourceOptions? opts = null)
public ManagedInstanceAdministrator(String name, ManagedInstanceAdministratorArgs args)
public ManagedInstanceAdministrator(String name, ManagedInstanceAdministratorArgs args, CustomResourceOptions options)

type: azure-native:sql:ManagedInstanceAdministrator
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
name string
The unique name of the resource.
args ManagedInstanceAdministratorArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args ManagedInstanceAdministratorArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args ManagedInstanceAdministratorArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args ManagedInstanceAdministratorArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args ManagedInstanceAdministratorArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

ManagedInstanceAdministrator Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The ManagedInstanceAdministrator resource accepts the following input properties:

AdministratorType string | Pulumi.AzureNative.Sql.ManagedInstanceAdministratorType

Type of the managed instance administrator.

Login string

Login name of the managed instance administrator.

ManagedInstanceName string

The name of the managed instance.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

Sid string

SID (object ID) of the managed instance administrator.

AdministratorName string
TenantId string

Tenant ID of the managed instance administrator.

AdministratorType string | ManagedInstanceAdministratorType

Type of the managed instance administrator.

Login string

Login name of the managed instance administrator.

ManagedInstanceName string

The name of the managed instance.

ResourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

Sid string

SID (object ID) of the managed instance administrator.

AdministratorName string
TenantId string

Tenant ID of the managed instance administrator.

administratorType String | ManagedInstanceAdministratorType

Type of the managed instance administrator.

login String

Login name of the managed instance administrator.

managedInstanceName String

The name of the managed instance.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sid String

SID (object ID) of the managed instance administrator.

administratorName String
tenantId String

Tenant ID of the managed instance administrator.

administratorType string | ManagedInstanceAdministratorType

Type of the managed instance administrator.

login string

Login name of the managed instance administrator.

managedInstanceName string

The name of the managed instance.

resourceGroupName string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sid string

SID (object ID) of the managed instance administrator.

administratorName string
tenantId string

Tenant ID of the managed instance administrator.

administrator_type str | ManagedInstanceAdministratorType

Type of the managed instance administrator.

login str

Login name of the managed instance administrator.

managed_instance_name str

The name of the managed instance.

resource_group_name str

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sid str

SID (object ID) of the managed instance administrator.

administrator_name str
tenant_id str

Tenant ID of the managed instance administrator.

administratorType String | "ActiveDirectory"

Type of the managed instance administrator.

login String

Login name of the managed instance administrator.

managedInstanceName String

The name of the managed instance.

resourceGroupName String

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

sid String

SID (object ID) of the managed instance administrator.

administratorName String
tenantId String

Tenant ID of the managed instance administrator.

Outputs

All input properties are implicitly available as output properties. Additionally, the ManagedInstanceAdministrator resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

Type string

Resource type.

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

Type string

Resource type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

type String

Resource type.

id string

The provider-assigned unique ID for this managed resource.

name string

Resource name.

type string

Resource type.

id str

The provider-assigned unique ID for this managed resource.

name str

Resource name.

type str

Resource type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

type String

Resource type.

Supporting Types

ManagedInstanceAdministratorType

ActiveDirectory
ActiveDirectory
ManagedInstanceAdministratorTypeActiveDirectory
ActiveDirectory
ActiveDirectory
ActiveDirectory
ActiveDirectory
ActiveDirectory
ACTIVE_DIRECTORY
ActiveDirectory
"ActiveDirectory"
ActiveDirectory

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sql:ManagedInstanceAdministrator ActiveDirectory /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/managedInstances/managedInstance/administrators/ActiveDirectory

Package Details

Repository
Azure Native pulumi/pulumi-azure-native
License
Apache-2.0