mysql.Grant

import * as pulumi from "@pulumi/pulumi";
import * as mysql from "@pulumi/mysql";

const jdoeUser = new mysql.User("jdoeUser", {
    host: "example.com",
    plaintextPassword: "password",
    user: "jdoe",
});
const jdoeGrant = new mysql.Grant("jdoeGrant", {
    database: "app",
    host: jdoeUser.host,
    privileges: [
        "SELECT",
        "UPDATE",
    ],
    user: jdoeUser.user,
});

import pulumi
import pulumi_mysql as mysql

jdoe_user = mysql.User("jdoeUser",
    host="example.com",
    plaintext_password="password",
    user="jdoe")
jdoe_grant = mysql.Grant("jdoeGrant",
    database="app",
    host=jdoe_user.host,
    privileges=[
        "SELECT",
        "UPDATE",
    ],
    user=jdoe_user.user)

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using MySql = Pulumi.MySql;

return await Deployment.RunAsync(() => 
{
    var jdoeUser = new MySql.User("jdoeUser", new()
    {
        Host = "example.com",
        PlaintextPassword = "password",
        UserName = "jdoe",
    });

    var jdoeGrant = new MySql.Grant("jdoeGrant", new()
    {
        Database = "app",
        Host = jdoeUser.Host,
        Privileges = new[]
        {
            "SELECT",
            "UPDATE",
        },
        User = jdoeUser.UserName,
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		jdoeUser, err := mysql.NewUser(ctx, "jdoeUser", &mysql.UserArgs{
			Host:              pulumi.String("example.com"),
			PlaintextPassword: pulumi.String("password"),
			User:              pulumi.String("jdoe"),
		})
		if err != nil {
			return err
		}
		_, err = mysql.NewGrant(ctx, "jdoeGrant", &mysql.GrantArgs{
			Database: pulumi.String("app"),
			Host:     jdoeUser.Host,
			Privileges: pulumi.StringArray{
				pulumi.String("SELECT"),
				pulumi.String("UPDATE"),
			},
			User: jdoeUser.User,
		})
		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.mysql.User;
import com.pulumi.mysql.UserArgs;
import com.pulumi.mysql.Grant;
import com.pulumi.mysql.GrantArgs;
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 jdoeUser = new User("jdoeUser", UserArgs.builder()        
            .host("example.com")
            .plaintextPassword("password")
            .user("jdoe")
            .build());

        var jdoeGrant = new Grant("jdoeGrant", GrantArgs.builder()        
            .database("app")
            .host(jdoeUser.host())
            .privileges(            
                "SELECT",
                "UPDATE")
            .user(jdoeUser.user())
            .build());

    }
}

resources:
  jdoeUser:
    type: mysql:User
    properties:
      host: example.com
      plaintextPassword: password
      user: jdoe
  jdoeGrant:
    type: mysql:Grant
    properties:
      database: app
      host: ${jdoeUser.host}
      privileges:
        - SELECT
        - UPDATE
      user: ${jdoeUser.user}

import * as pulumi from "@pulumi/pulumi";
import * as mysql from "@pulumi/mysql";

const developerRole = new mysql.Role("developerRole", {});
const developerGrant = new mysql.Grant("developerGrant", {
    database: "app",
    privileges: [
        "SELECT",
        "UPDATE",
    ],
    role: developerRole.name,
});

import pulumi
import pulumi_mysql as mysql

developer_role = mysql.Role("developerRole")
developer_grant = mysql.Grant("developerGrant",
    database="app",
    privileges=[
        "SELECT",
        "UPDATE",
    ],
    role=developer_role.name)

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using MySql = Pulumi.MySql;

return await Deployment.RunAsync(() => 
{
    var developerRole = new MySql.Role("developerRole");

    var developerGrant = new MySql.Grant("developerGrant", new()
    {
        Database = "app",
        Privileges = new[]
        {
            "SELECT",
            "UPDATE",
        },
        Role = developerRole.Name,
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		developerRole, err := mysql.NewRole(ctx, "developerRole", nil)
		if err != nil {
			return err
		}
		_, err = mysql.NewGrant(ctx, "developerGrant", &mysql.GrantArgs{
			Database: pulumi.String("app"),
			Privileges: pulumi.StringArray{
				pulumi.String("SELECT"),
				pulumi.String("UPDATE"),
			},
			Role: developerRole.Name,
		})
		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.mysql.Role;
import com.pulumi.mysql.Grant;
import com.pulumi.mysql.GrantArgs;
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 developerRole = new Role("developerRole");

        var developerGrant = new Grant("developerGrant", GrantArgs.builder()        
            .database("app")
            .privileges(            
                "SELECT",
                "UPDATE")
            .role(developerRole.name())
            .build());

    }
}

resources:
  developerRole:
    type: mysql:Role
  developerGrant:
    type: mysql:Grant
    properties:
      database: app
      privileges:
        - SELECT
        - UPDATE
      role: ${developerRole.name}

import * as pulumi from "@pulumi/pulumi";
import * as mysql from "@pulumi/mysql";

const jdoe = new mysql.User("jdoe", {
    host: "example.com",
    plaintextPassword: "password",
    user: "jdoe",
});
const developerRole = new mysql.Role("developerRole", {});
const developerGrant = new mysql.Grant("developerGrant", {
    database: "app",
    host: jdoe.host,
    roles: [developerRole.name],
    user: jdoe.user,
});

import pulumi
import pulumi_mysql as mysql

jdoe = mysql.User("jdoe",
    host="example.com",
    plaintext_password="password",
    user="jdoe")
developer_role = mysql.Role("developerRole")
developer_grant = mysql.Grant("developerGrant",
    database="app",
    host=jdoe.host,
    roles=[developer_role.name],
    user=jdoe.user)

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using MySql = Pulumi.MySql;

return await Deployment.RunAsync(() => 
{
    var jdoe = new MySql.User("jdoe", new()
    {
        Host = "example.com",
        PlaintextPassword = "password",
        UserName = "jdoe",
    });

    var developerRole = new MySql.Role("developerRole");

    var developerGrant = new MySql.Grant("developerGrant", new()
    {
        Database = "app",
        Host = jdoe.Host,
        Roles = new[]
        {
            developerRole.Name,
        },
        User = jdoe.UserName,
    });

});

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		jdoe, err := mysql.NewUser(ctx, "jdoe", &mysql.UserArgs{
			Host:              pulumi.String("example.com"),
			PlaintextPassword: pulumi.String("password"),
			User:              pulumi.String("jdoe"),
		})
		if err != nil {
			return err
		}
		developerRole, err := mysql.NewRole(ctx, "developerRole", nil)
		if err != nil {
			return err
		}
		_, err = mysql.NewGrant(ctx, "developerGrant", &mysql.GrantArgs{
			Database: pulumi.String("app"),
			Host:     jdoe.Host,
			Roles: pulumi.StringArray{
				developerRole.Name,
			},
			User: jdoe.User,
		})
		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.mysql.User;
import com.pulumi.mysql.UserArgs;
import com.pulumi.mysql.Role;
import com.pulumi.mysql.Grant;
import com.pulumi.mysql.GrantArgs;
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 jdoe = new User("jdoe", UserArgs.builder()        
            .host("example.com")
            .plaintextPassword("password")
            .user("jdoe")
            .build());

        var developerRole = new Role("developerRole");

        var developerGrant = new Grant("developerGrant", GrantArgs.builder()        
            .database("app")
            .host(jdoe.host())
            .roles(developerRole.name())
            .user(jdoe.user())
            .build());

    }
}

resources:
  jdoe:
    type: mysql:User
    properties:
      host: example.com
      plaintextPassword: password
      user: jdoe
  developerRole:
    type: mysql:Role
  developerGrant:
    type: mysql:Grant
    properties:
      database: app
      host: ${jdoe.host}
      roles:
        - ${developerRole.name}
      user: ${jdoe.user}