mssql.ServerPermission

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Mssql = Pulumi.Mssql;
using Mssql = Pulumiverse.Mssql;

return await Deployment.RunAsync(() => 
{
    var example = Mssql.GetSqlLogin.Invoke(new()
    {
        Name = "example_login",
    });

    var connectToExample = new Mssql.ServerPermission("connectToExample", new()
    {
        PrincipalId = example.Apply(getSqlLoginResult => getSqlLoginResult.PrincipalId),
        Permission = "CONNECT SQL",
        WithGrantOption = true,
    });

});

package main

import (
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
	"github.com/pulumiverse/pulumi-mssql/sdk/go/mssql"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		example, err := mssql.LookupSqlLogin(ctx, &mssql.LookupSqlLoginArgs{
			Name: "example_login",
		}, nil)
		if err != nil {
			return err
		}
		_, err = mssql.NewServerPermission(ctx, "connectToExample", &mssql.ServerPermissionArgs{
			PrincipalId:     *pulumi.String(example.PrincipalId),
			Permission:      pulumi.String("CONNECT SQL"),
			WithGrantOption: pulumi.Bool(true),
		})
		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.mssql.MssqlFunctions;
import com.pulumi.mssql.inputs.GetSqlLoginArgs;
import com.pulumi.mssql.ServerPermission;
import com.pulumi.mssql.ServerPermissionArgs;
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 example = MssqlFunctions.getSqlLogin(GetSqlLoginArgs.builder()
            .name("example_login")
            .build());

        var connectToExample = new ServerPermission("connectToExample", ServerPermissionArgs.builder()        
            .principalId(example.applyValue(getSqlLoginResult -> getSqlLoginResult.principalId()))
            .permission("CONNECT SQL")
            .withGrantOption(true)
            .build());

    }
}

import pulumi
import pulumi_mssql as mssql
import pulumiverse_mssql as mssql

example = mssql.get_sql_login(name="example_login")
connect_to_example = mssql.ServerPermission("connectToExample",
    principal_id=example.principal_id,
    permission="CONNECT SQL",
    with_grant_option=True)

import * as pulumi from "@pulumi/pulumi";
import * as mssql from "@pulumi/mssql";
import * as mssql from "@pulumiverse/mssql";

const example = mssql.getSqlLogin({
    name: "example_login",
});
const connectToExample = new mssql.ServerPermission("connectToExample", {
    principalId: example.then(example => example.principalId),
    permission: "CONNECT SQL",
    withGrantOption: true,
});

resources:
  connectToExample:
    type: mssql:ServerPermission
    properties:
      principalId: ${example.principalId}
      permission: CONNECT SQL
      withGrantOption: true
variables:
  example:
    fn::invoke:
      Function: mssql:getSqlLogin
      Arguments:
        name: example_login