mssql.SchemaPermission

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

const exampleDatabase = mssql.getDatabase({
    name: "example",
});
const exampleSqlUser = exampleDatabase.then(exampleDatabase => mssql.getSqlUser({
    name: "example_user",
    databaseId: exampleDatabase.id,
}));
const exampleSchema = exampleDatabase.then(exampleDatabase => mssql.getSchema({
    name: "example_schema",
    databaseId: exampleDatabase.id,
}));
const deleteToExample = new mssql.SchemaPermission("deleteToExample", {
    schemaId: exampleSchema.then(exampleSchema => exampleSchema.id),
    principalId: exampleSqlUser.then(exampleSqlUser => exampleSqlUser.id),
    permission: "DELETE",
});

import pulumi
import pulumi_mssql as mssql
import pulumiverse_mssql as mssql

example_database = mssql.get_database(name="example")
example_sql_user = mssql.get_sql_user(name="example_user",
    database_id=example_database.id)
example_schema = mssql.get_schema(name="example_schema",
    database_id=example_database.id)
delete_to_example = mssql.SchemaPermission("deleteToExample",
    schema_id=example_schema.id,
    principal_id=example_sql_user.id,
    permission="DELETE")

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 {
		exampleDatabase, err := mssql.LookupDatabase(ctx, &mssql.LookupDatabaseArgs{
			Name: "example",
		}, nil)
		if err != nil {
			return err
		}
		exampleSqlUser, err := mssql.LookupSqlUser(ctx, &mssql.LookupSqlUserArgs{
			Name:       "example_user",
			DatabaseId: pulumi.StringRef(exampleDatabase.Id),
		}, nil)
		if err != nil {
			return err
		}
		exampleSchema, err := mssql.LookupSchema(ctx, &mssql.LookupSchemaArgs{
			Name:       pulumi.StringRef("example_schema"),
			DatabaseId: pulumi.StringRef(exampleDatabase.Id),
		}, nil)
		if err != nil {
			return err
		}
		_, err = mssql.NewSchemaPermission(ctx, "deleteToExample", &mssql.SchemaPermissionArgs{
			SchemaId:    pulumi.String(exampleSchema.Id),
			PrincipalId: pulumi.String(exampleSqlUser.Id),
			Permission:  pulumi.String("DELETE"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

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

    var exampleSqlUser = Mssql.GetSqlUser.Invoke(new()
    {
        Name = "example_user",
        DatabaseId = exampleDatabase.Apply(getDatabaseResult => getDatabaseResult.Id),
    });

    var exampleSchema = Mssql.GetSchema.Invoke(new()
    {
        Name = "example_schema",
        DatabaseId = exampleDatabase.Apply(getDatabaseResult => getDatabaseResult.Id),
    });

    var deleteToExample = new Mssql.SchemaPermission("deleteToExample", new()
    {
        SchemaId = exampleSchema.Apply(getSchemaResult => getSchemaResult.Id),
        PrincipalId = exampleSqlUser.Apply(getSqlUserResult => getSqlUserResult.Id),
        Permission = "DELETE",
    });

});

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.GetDatabaseArgs;
import com.pulumi.mssql.inputs.GetSqlUserArgs;
import com.pulumi.mssql.inputs.GetSchemaArgs;
import com.pulumi.mssql.SchemaPermission;
import com.pulumi.mssql.SchemaPermissionArgs;
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 exampleDatabase = MssqlFunctions.getDatabase(GetDatabaseArgs.builder()
            .name("example")
            .build());

        final var exampleSqlUser = MssqlFunctions.getSqlUser(GetSqlUserArgs.builder()
            .name("example_user")
            .databaseId(exampleDatabase.applyValue(getDatabaseResult -> getDatabaseResult.id()))
            .build());

        final var exampleSchema = MssqlFunctions.getSchema(GetSchemaArgs.builder()
            .name("example_schema")
            .databaseId(exampleDatabase.applyValue(getDatabaseResult -> getDatabaseResult.id()))
            .build());

        var deleteToExample = new SchemaPermission("deleteToExample", SchemaPermissionArgs.builder()
            .schemaId(exampleSchema.applyValue(getSchemaResult -> getSchemaResult.id()))
            .principalId(exampleSqlUser.applyValue(getSqlUserResult -> getSqlUserResult.id()))
            .permission("DELETE")
            .build());

    }
}

resources:
  deleteToExample:
    type: mssql:SchemaPermission
    properties:
      schemaId: ${exampleSchema.id}
      principalId: ${exampleSqlUser.id}
      permission: DELETE
variables:
  exampleDatabase:
    fn::invoke:
      Function: mssql:getDatabase
      Arguments:
        name: example
  exampleSqlUser:
    fn::invoke:
      Function: mssql:getSqlUser
      Arguments:
        name: example_user
        databaseId: ${exampleDatabase.id}
  exampleSchema:
    fn::invoke:
      Function: mssql:getSchema
      Arguments:
        name: example_schema
        databaseId: ${exampleDatabase.id}

var schemaPermissionResource = new Mssql.SchemaPermission("schemaPermissionResource", new()
{
    Permission = "string",
    PrincipalId = "string",
    SchemaId = "string",
    WithGrantOption = false,
});

example, err := mssql.NewSchemaPermission(ctx, "schemaPermissionResource", &mssql.SchemaPermissionArgs{
	Permission:      pulumi.String("string"),
	PrincipalId:     pulumi.String("string"),
	SchemaId:        pulumi.String("string"),
	WithGrantOption: pulumi.Bool(false),
})

var schemaPermissionResource = new SchemaPermission("schemaPermissionResource", SchemaPermissionArgs.builder()
    .permission("string")
    .principalId("string")
    .schemaId("string")
    .withGrantOption(false)
    .build());

schema_permission_resource = mssql.SchemaPermission("schemaPermissionResource",
    permission="string",
    principal_id="string",
    schema_id="string",
    with_grant_option=False)

const schemaPermissionResource = new mssql.SchemaPermission("schemaPermissionResource", {
    permission: "string",
    principalId: "string",
    schemaId: "string",
    withGrantOption: false,
});

type: mssql:SchemaPermission
properties:
    permission: string
    principalId: string
    schemaId: string
    withGrantOption: false