1. Packages
  2. Snowflake
  3. API Docs
  4. GrantPrivilegesToRole
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

snowflake.GrantPrivilegesToRole

Explore with Pulumi AI

snowflake logo
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

    Deprecation This resource is deprecated and will be removed in a future major version release. Please use snowflake.GrantPrivilegesToAccountRole instead.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as snowflake from "@pulumi/snowflake";
    
    //#################################
    //## global privileges
    //#################################
    // list of privileges
    const g1 = new snowflake.GrantPrivilegesToRole("g1", {
        privileges: [
            "MODIFY",
            "USAGE",
        ],
        roleName: r.name,
        onAccount: true,
    });
    // all privileges + grant option
    const g2 = new snowflake.GrantPrivilegesToRole("g2", {
        roleName: r.name,
        onAccount: true,
        allPrivileges: true,
        withGrantOption: true,
    });
    //#################################
    //## account object privileges
    //#################################
    // list of privileges
    const g3 = new snowflake.GrantPrivilegesToRole("g3", {
        privileges: [
            "CREATE",
            "MONITOR",
        ],
        roleName: r.name,
        onAccountObject: {
            objectType: "DATABASE",
            objectName: d.name,
        },
    });
    // all privileges + grant option
    const g4 = new snowflake.GrantPrivilegesToRole("g4", {
        roleName: r.name,
        onAccountObject: {
            objectType: "DATABASE",
            objectName: d.name,
        },
        allPrivileges: true,
        withGrantOption: true,
    });
    //#################################
    //## schema privileges
    //#################################
    // list of privileges
    const g5 = new snowflake.GrantPrivilegesToRole("g5", {
        privileges: [
            "MODIFY",
            "CREATE TABLE",
        ],
        roleName: r.name,
        onSchema: {
            schemaName: "\"my_db\".\"my_schema\"",
        },
    });
    // all privileges + grant option
    const g6 = new snowflake.GrantPrivilegesToRole("g6", {
        roleName: r.name,
        onSchema: {
            schemaName: "\"my_db\".\"my_schema\"",
        },
        allPrivileges: true,
        withGrantOption: true,
    });
    // all schemas in database
    const g7 = new snowflake.GrantPrivilegesToRole("g7", {
        privileges: [
            "MODIFY",
            "CREATE TABLE",
        ],
        roleName: r.name,
        onSchema: {
            allSchemasInDatabase: d.name,
        },
    });
    // future schemas in database
    const g8 = new snowflake.GrantPrivilegesToRole("g8", {
        privileges: [
            "MODIFY",
            "CREATE TABLE",
        ],
        roleName: r.name,
        onSchema: {
            futureSchemasInDatabase: d.name,
        },
    });
    //#################################
    //## schema object privileges
    //#################################
    // list of privileges
    const g9 = new snowflake.GrantPrivilegesToRole("g9", {
        privileges: [
            "SELECT",
            "REFERENCES",
        ],
        roleName: r.name,
        onSchemaObject: {
            objectType: "VIEW",
            objectName: "\"my_db\".\"my_schema\".\"my_view\"",
        },
    });
    // all privileges + grant option
    const g10 = new snowflake.GrantPrivilegesToRole("g10", {
        roleName: r.name,
        onSchemaObject: {
            objectType: "VIEW",
            objectName: "\"my_db\".\"my_schema\".\"my_view\"",
        },
        allPrivileges: true,
        withGrantOption: true,
    });
    // all in database
    const g11 = new snowflake.GrantPrivilegesToRole("g11", {
        privileges: [
            "SELECT",
            "INSERT",
        ],
        roleName: r.name,
        onSchemaObject: {
            all: {
                objectTypePlural: "TABLES",
                inDatabase: d.name,
            },
        },
    });
    // all in schema
    const g12 = new snowflake.GrantPrivilegesToRole("g12", {
        privileges: [
            "SELECT",
            "INSERT",
        ],
        roleName: r.name,
        onSchemaObject: {
            all: {
                objectTypePlural: "TABLES",
                inSchema: "\"my_db\".\"my_schema\"",
            },
        },
    });
    // future in database
    const g13 = new snowflake.GrantPrivilegesToRole("g13", {
        privileges: [
            "SELECT",
            "INSERT",
        ],
        roleName: r.name,
        onSchemaObject: {
            future: {
                objectTypePlural: "TABLES",
                inDatabase: d.name,
            },
        },
    });
    // future in schema
    const g14 = new snowflake.GrantPrivilegesToRole("g14", {
        privileges: [
            "SELECT",
            "INSERT",
        ],
        roleName: r.name,
        onSchemaObject: {
            future: {
                objectTypePlural: "TABLES",
                inSchema: "\"my_db\".\"my_schema\"",
            },
        },
    });
    
    import pulumi
    import pulumi_snowflake as snowflake
    
    ##################################
    ### global privileges
    ##################################
    # list of privileges
    g1 = snowflake.GrantPrivilegesToRole("g1",
        privileges=[
            "MODIFY",
            "USAGE",
        ],
        role_name=r["name"],
        on_account=True)
    # all privileges + grant option
    g2 = snowflake.GrantPrivilegesToRole("g2",
        role_name=r["name"],
        on_account=True,
        all_privileges=True,
        with_grant_option=True)
    ##################################
    ### account object privileges
    ##################################
    # list of privileges
    g3 = snowflake.GrantPrivilegesToRole("g3",
        privileges=[
            "CREATE",
            "MONITOR",
        ],
        role_name=r["name"],
        on_account_object=snowflake.GrantPrivilegesToRoleOnAccountObjectArgs(
            object_type="DATABASE",
            object_name=d["name"],
        ))
    # all privileges + grant option
    g4 = snowflake.GrantPrivilegesToRole("g4",
        role_name=r["name"],
        on_account_object=snowflake.GrantPrivilegesToRoleOnAccountObjectArgs(
            object_type="DATABASE",
            object_name=d["name"],
        ),
        all_privileges=True,
        with_grant_option=True)
    ##################################
    ### schema privileges
    ##################################
    # list of privileges
    g5 = snowflake.GrantPrivilegesToRole("g5",
        privileges=[
            "MODIFY",
            "CREATE TABLE",
        ],
        role_name=r["name"],
        on_schema=snowflake.GrantPrivilegesToRoleOnSchemaArgs(
            schema_name="\"my_db\".\"my_schema\"",
        ))
    # all privileges + grant option
    g6 = snowflake.GrantPrivilegesToRole("g6",
        role_name=r["name"],
        on_schema=snowflake.GrantPrivilegesToRoleOnSchemaArgs(
            schema_name="\"my_db\".\"my_schema\"",
        ),
        all_privileges=True,
        with_grant_option=True)
    # all schemas in database
    g7 = snowflake.GrantPrivilegesToRole("g7",
        privileges=[
            "MODIFY",
            "CREATE TABLE",
        ],
        role_name=r["name"],
        on_schema=snowflake.GrantPrivilegesToRoleOnSchemaArgs(
            all_schemas_in_database=d["name"],
        ))
    # future schemas in database
    g8 = snowflake.GrantPrivilegesToRole("g8",
        privileges=[
            "MODIFY",
            "CREATE TABLE",
        ],
        role_name=r["name"],
        on_schema=snowflake.GrantPrivilegesToRoleOnSchemaArgs(
            future_schemas_in_database=d["name"],
        ))
    ##################################
    ### schema object privileges
    ##################################
    # list of privileges
    g9 = snowflake.GrantPrivilegesToRole("g9",
        privileges=[
            "SELECT",
            "REFERENCES",
        ],
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            object_type="VIEW",
            object_name="\"my_db\".\"my_schema\".\"my_view\"",
        ))
    # all privileges + grant option
    g10 = snowflake.GrantPrivilegesToRole("g10",
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            object_type="VIEW",
            object_name="\"my_db\".\"my_schema\".\"my_view\"",
        ),
        all_privileges=True,
        with_grant_option=True)
    # all in database
    g11 = snowflake.GrantPrivilegesToRole("g11",
        privileges=[
            "SELECT",
            "INSERT",
        ],
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            all=snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs(
                object_type_plural="TABLES",
                in_database=d["name"],
            ),
        ))
    # all in schema
    g12 = snowflake.GrantPrivilegesToRole("g12",
        privileges=[
            "SELECT",
            "INSERT",
        ],
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            all=snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs(
                object_type_plural="TABLES",
                in_schema="\"my_db\".\"my_schema\"",
            ),
        ))
    # future in database
    g13 = snowflake.GrantPrivilegesToRole("g13",
        privileges=[
            "SELECT",
            "INSERT",
        ],
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            future=snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs(
                object_type_plural="TABLES",
                in_database=d["name"],
            ),
        ))
    # future in schema
    g14 = snowflake.GrantPrivilegesToRole("g14",
        privileges=[
            "SELECT",
            "INSERT",
        ],
        role_name=r["name"],
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            future=snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs(
                object_type_plural="TABLES",
                in_schema="\"my_db\".\"my_schema\"",
            ),
        ))
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-snowflake/sdk/go/snowflake"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		// #################################
    		// ## global privileges
    		// #################################
    		// list of privileges
    		_, err := snowflake.NewGrantPrivilegesToRole(ctx, "g1", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("MODIFY"),
    				pulumi.String("USAGE"),
    			},
    			RoleName:  pulumi.Any(r.Name),
    			OnAccount: pulumi.Bool(true),
    		})
    		if err != nil {
    			return err
    		}
    		// all privileges + grant option
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g2", &snowflake.GrantPrivilegesToRoleArgs{
    			RoleName:        pulumi.Any(r.Name),
    			OnAccount:       pulumi.Bool(true),
    			AllPrivileges:   pulumi.Bool(true),
    			WithGrantOption: pulumi.Bool(true),
    		})
    		if err != nil {
    			return err
    		}
    		// list of privileges
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g3", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("CREATE"),
    				pulumi.String("MONITOR"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnAccountObject: &snowflake.GrantPrivilegesToRoleOnAccountObjectArgs{
    				ObjectType: pulumi.String("DATABASE"),
    				ObjectName: pulumi.Any(d.Name),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// all privileges + grant option
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g4", &snowflake.GrantPrivilegesToRoleArgs{
    			RoleName: pulumi.Any(r.Name),
    			OnAccountObject: &snowflake.GrantPrivilegesToRoleOnAccountObjectArgs{
    				ObjectType: pulumi.String("DATABASE"),
    				ObjectName: pulumi.Any(d.Name),
    			},
    			AllPrivileges:   pulumi.Bool(true),
    			WithGrantOption: pulumi.Bool(true),
    		})
    		if err != nil {
    			return err
    		}
    		// list of privileges
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g5", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("MODIFY"),
    				pulumi.String("CREATE TABLE"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchema: &snowflake.GrantPrivilegesToRoleOnSchemaArgs{
    				SchemaName: pulumi.String("\"my_db\".\"my_schema\""),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// all privileges + grant option
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g6", &snowflake.GrantPrivilegesToRoleArgs{
    			RoleName: pulumi.Any(r.Name),
    			OnSchema: &snowflake.GrantPrivilegesToRoleOnSchemaArgs{
    				SchemaName: pulumi.String("\"my_db\".\"my_schema\""),
    			},
    			AllPrivileges:   pulumi.Bool(true),
    			WithGrantOption: pulumi.Bool(true),
    		})
    		if err != nil {
    			return err
    		}
    		// all schemas in database
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g7", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("MODIFY"),
    				pulumi.String("CREATE TABLE"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchema: &snowflake.GrantPrivilegesToRoleOnSchemaArgs{
    				AllSchemasInDatabase: pulumi.Any(d.Name),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// future schemas in database
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g8", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("MODIFY"),
    				pulumi.String("CREATE TABLE"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchema: &snowflake.GrantPrivilegesToRoleOnSchemaArgs{
    				FutureSchemasInDatabase: pulumi.Any(d.Name),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// list of privileges
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g9", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("SELECT"),
    				pulumi.String("REFERENCES"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				ObjectType: pulumi.String("VIEW"),
    				ObjectName: pulumi.String("\"my_db\".\"my_schema\".\"my_view\""),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// all privileges + grant option
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g10", &snowflake.GrantPrivilegesToRoleArgs{
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				ObjectType: pulumi.String("VIEW"),
    				ObjectName: pulumi.String("\"my_db\".\"my_schema\".\"my_view\""),
    			},
    			AllPrivileges:   pulumi.Bool(true),
    			WithGrantOption: pulumi.Bool(true),
    		})
    		if err != nil {
    			return err
    		}
    		// all in database
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g11", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("SELECT"),
    				pulumi.String("INSERT"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				All: &snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs{
    					ObjectTypePlural: pulumi.String("TABLES"),
    					InDatabase:       pulumi.Any(d.Name),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// all in schema
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g12", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("SELECT"),
    				pulumi.String("INSERT"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				All: &snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs{
    					ObjectTypePlural: pulumi.String("TABLES"),
    					InSchema:         pulumi.String("\"my_db\".\"my_schema\""),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// future in database
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g13", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("SELECT"),
    				pulumi.String("INSERT"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				Future: &snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs{
    					ObjectTypePlural: pulumi.String("TABLES"),
    					InDatabase:       pulumi.Any(d.Name),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		// future in schema
    		_, err = snowflake.NewGrantPrivilegesToRole(ctx, "g14", &snowflake.GrantPrivilegesToRoleArgs{
    			Privileges: pulumi.StringArray{
    				pulumi.String("SELECT"),
    				pulumi.String("INSERT"),
    			},
    			RoleName: pulumi.Any(r.Name),
    			OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    				Future: &snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs{
    					ObjectTypePlural: pulumi.String("TABLES"),
    					InSchema:         pulumi.String("\"my_db\".\"my_schema\""),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Snowflake = Pulumi.Snowflake;
    
    return await Deployment.RunAsync(() => 
    {
        //#################################
        //## global privileges
        //#################################
        // list of privileges
        var g1 = new Snowflake.GrantPrivilegesToRole("g1", new()
        {
            Privileges = new[]
            {
                "MODIFY",
                "USAGE",
            },
            RoleName = r.Name,
            OnAccount = true,
        });
    
        // all privileges + grant option
        var g2 = new Snowflake.GrantPrivilegesToRole("g2", new()
        {
            RoleName = r.Name,
            OnAccount = true,
            AllPrivileges = true,
            WithGrantOption = true,
        });
    
        //#################################
        //## account object privileges
        //#################################
        // list of privileges
        var g3 = new Snowflake.GrantPrivilegesToRole("g3", new()
        {
            Privileges = new[]
            {
                "CREATE",
                "MONITOR",
            },
            RoleName = r.Name,
            OnAccountObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnAccountObjectArgs
            {
                ObjectType = "DATABASE",
                ObjectName = d.Name,
            },
        });
    
        // all privileges + grant option
        var g4 = new Snowflake.GrantPrivilegesToRole("g4", new()
        {
            RoleName = r.Name,
            OnAccountObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnAccountObjectArgs
            {
                ObjectType = "DATABASE",
                ObjectName = d.Name,
            },
            AllPrivileges = true,
            WithGrantOption = true,
        });
    
        //#################################
        //## schema privileges
        //#################################
        // list of privileges
        var g5 = new Snowflake.GrantPrivilegesToRole("g5", new()
        {
            Privileges = new[]
            {
                "MODIFY",
                "CREATE TABLE",
            },
            RoleName = r.Name,
            OnSchema = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaArgs
            {
                SchemaName = "\"my_db\".\"my_schema\"",
            },
        });
    
        // all privileges + grant option
        var g6 = new Snowflake.GrantPrivilegesToRole("g6", new()
        {
            RoleName = r.Name,
            OnSchema = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaArgs
            {
                SchemaName = "\"my_db\".\"my_schema\"",
            },
            AllPrivileges = true,
            WithGrantOption = true,
        });
    
        // all schemas in database
        var g7 = new Snowflake.GrantPrivilegesToRole("g7", new()
        {
            Privileges = new[]
            {
                "MODIFY",
                "CREATE TABLE",
            },
            RoleName = r.Name,
            OnSchema = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaArgs
            {
                AllSchemasInDatabase = d.Name,
            },
        });
    
        // future schemas in database
        var g8 = new Snowflake.GrantPrivilegesToRole("g8", new()
        {
            Privileges = new[]
            {
                "MODIFY",
                "CREATE TABLE",
            },
            RoleName = r.Name,
            OnSchema = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaArgs
            {
                FutureSchemasInDatabase = d.Name,
            },
        });
    
        //#################################
        //## schema object privileges
        //#################################
        // list of privileges
        var g9 = new Snowflake.GrantPrivilegesToRole("g9", new()
        {
            Privileges = new[]
            {
                "SELECT",
                "REFERENCES",
            },
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                ObjectType = "VIEW",
                ObjectName = "\"my_db\".\"my_schema\".\"my_view\"",
            },
        });
    
        // all privileges + grant option
        var g10 = new Snowflake.GrantPrivilegesToRole("g10", new()
        {
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                ObjectType = "VIEW",
                ObjectName = "\"my_db\".\"my_schema\".\"my_view\"",
            },
            AllPrivileges = true,
            WithGrantOption = true,
        });
    
        // all in database
        var g11 = new Snowflake.GrantPrivilegesToRole("g11", new()
        {
            Privileges = new[]
            {
                "SELECT",
                "INSERT",
            },
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                All = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectAllArgs
                {
                    ObjectTypePlural = "TABLES",
                    InDatabase = d.Name,
                },
            },
        });
    
        // all in schema
        var g12 = new Snowflake.GrantPrivilegesToRole("g12", new()
        {
            Privileges = new[]
            {
                "SELECT",
                "INSERT",
            },
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                All = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectAllArgs
                {
                    ObjectTypePlural = "TABLES",
                    InSchema = "\"my_db\".\"my_schema\"",
                },
            },
        });
    
        // future in database
        var g13 = new Snowflake.GrantPrivilegesToRole("g13", new()
        {
            Privileges = new[]
            {
                "SELECT",
                "INSERT",
            },
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                Future = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectFutureArgs
                {
                    ObjectTypePlural = "TABLES",
                    InDatabase = d.Name,
                },
            },
        });
    
        // future in schema
        var g14 = new Snowflake.GrantPrivilegesToRole("g14", new()
        {
            Privileges = new[]
            {
                "SELECT",
                "INSERT",
            },
            RoleName = r.Name,
            OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
            {
                Future = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectFutureArgs
                {
                    ObjectTypePlural = "TABLES",
                    InSchema = "\"my_db\".\"my_schema\"",
                },
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.snowflake.GrantPrivilegesToRole;
    import com.pulumi.snowflake.GrantPrivilegesToRoleArgs;
    import com.pulumi.snowflake.inputs.GrantPrivilegesToRoleOnAccountObjectArgs;
    import com.pulumi.snowflake.inputs.GrantPrivilegesToRoleOnSchemaArgs;
    import com.pulumi.snowflake.inputs.GrantPrivilegesToRoleOnSchemaObjectArgs;
    import com.pulumi.snowflake.inputs.GrantPrivilegesToRoleOnSchemaObjectAllArgs;
    import com.pulumi.snowflake.inputs.GrantPrivilegesToRoleOnSchemaObjectFutureArgs;
    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) {
            //#################################
            //## global privileges
            //#################################
            // list of privileges
            var g1 = new GrantPrivilegesToRole("g1", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "MODIFY",
                    "USAGE")
                .roleName(r.name())
                .onAccount(true)
                .build());
    
            // all privileges + grant option
            var g2 = new GrantPrivilegesToRole("g2", GrantPrivilegesToRoleArgs.builder()
                .roleName(r.name())
                .onAccount(true)
                .allPrivileges(true)
                .withGrantOption(true)
                .build());
    
            //#################################
            //## account object privileges
            //#################################
            // list of privileges
            var g3 = new GrantPrivilegesToRole("g3", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "CREATE",
                    "MONITOR")
                .roleName(r.name())
                .onAccountObject(GrantPrivilegesToRoleOnAccountObjectArgs.builder()
                    .objectType("DATABASE")
                    .objectName(d.name())
                    .build())
                .build());
    
            // all privileges + grant option
            var g4 = new GrantPrivilegesToRole("g4", GrantPrivilegesToRoleArgs.builder()
                .roleName(r.name())
                .onAccountObject(GrantPrivilegesToRoleOnAccountObjectArgs.builder()
                    .objectType("DATABASE")
                    .objectName(d.name())
                    .build())
                .allPrivileges(true)
                .withGrantOption(true)
                .build());
    
            //#################################
            //## schema privileges
            //#################################
            // list of privileges
            var g5 = new GrantPrivilegesToRole("g5", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "MODIFY",
                    "CREATE TABLE")
                .roleName(r.name())
                .onSchema(GrantPrivilegesToRoleOnSchemaArgs.builder()
                    .schemaName("\"my_db\".\"my_schema\"")
                    .build())
                .build());
    
            // all privileges + grant option
            var g6 = new GrantPrivilegesToRole("g6", GrantPrivilegesToRoleArgs.builder()
                .roleName(r.name())
                .onSchema(GrantPrivilegesToRoleOnSchemaArgs.builder()
                    .schemaName("\"my_db\".\"my_schema\"")
                    .build())
                .allPrivileges(true)
                .withGrantOption(true)
                .build());
    
            // all schemas in database
            var g7 = new GrantPrivilegesToRole("g7", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "MODIFY",
                    "CREATE TABLE")
                .roleName(r.name())
                .onSchema(GrantPrivilegesToRoleOnSchemaArgs.builder()
                    .allSchemasInDatabase(d.name())
                    .build())
                .build());
    
            // future schemas in database
            var g8 = new GrantPrivilegesToRole("g8", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "MODIFY",
                    "CREATE TABLE")
                .roleName(r.name())
                .onSchema(GrantPrivilegesToRoleOnSchemaArgs.builder()
                    .futureSchemasInDatabase(d.name())
                    .build())
                .build());
    
            //#################################
            //## schema object privileges
            //#################################
            // list of privileges
            var g9 = new GrantPrivilegesToRole("g9", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "SELECT",
                    "REFERENCES")
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .objectType("VIEW")
                    .objectName("\"my_db\".\"my_schema\".\"my_view\"")
                    .build())
                .build());
    
            // all privileges + grant option
            var g10 = new GrantPrivilegesToRole("g10", GrantPrivilegesToRoleArgs.builder()
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .objectType("VIEW")
                    .objectName("\"my_db\".\"my_schema\".\"my_view\"")
                    .build())
                .allPrivileges(true)
                .withGrantOption(true)
                .build());
    
            // all in database
            var g11 = new GrantPrivilegesToRole("g11", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "SELECT",
                    "INSERT")
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .all(GrantPrivilegesToRoleOnSchemaObjectAllArgs.builder()
                        .objectTypePlural("TABLES")
                        .inDatabase(d.name())
                        .build())
                    .build())
                .build());
    
            // all in schema
            var g12 = new GrantPrivilegesToRole("g12", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "SELECT",
                    "INSERT")
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .all(GrantPrivilegesToRoleOnSchemaObjectAllArgs.builder()
                        .objectTypePlural("TABLES")
                        .inSchema("\"my_db\".\"my_schema\"")
                        .build())
                    .build())
                .build());
    
            // future in database
            var g13 = new GrantPrivilegesToRole("g13", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "SELECT",
                    "INSERT")
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .future(GrantPrivilegesToRoleOnSchemaObjectFutureArgs.builder()
                        .objectTypePlural("TABLES")
                        .inDatabase(d.name())
                        .build())
                    .build())
                .build());
    
            // future in schema
            var g14 = new GrantPrivilegesToRole("g14", GrantPrivilegesToRoleArgs.builder()
                .privileges(            
                    "SELECT",
                    "INSERT")
                .roleName(r.name())
                .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
                    .future(GrantPrivilegesToRoleOnSchemaObjectFutureArgs.builder()
                        .objectTypePlural("TABLES")
                        .inSchema("\"my_db\".\"my_schema\"")
                        .build())
                    .build())
                .build());
    
        }
    }
    
    resources:
      ##################################
      ### global privileges
      ##################################
    
      # list of privileges
      g1:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - MODIFY
            - USAGE
          roleName: ${r.name}
          onAccount: true
      # all privileges + grant option
      g2: ##################################
      ### account object privileges
      ##################################
        type: snowflake:GrantPrivilegesToRole
        properties:
          roleName: ${r.name}
          onAccount: true
          allPrivileges: true
          withGrantOption: true
      # list of privileges
      g3:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - CREATE
            - MONITOR
          roleName: ${r.name}
          onAccountObject:
            objectType: DATABASE
            objectName: ${d.name}
      # all privileges + grant option
      g4: ##################################
      ### schema privileges
      ##################################
        type: snowflake:GrantPrivilegesToRole
        properties:
          roleName: ${r.name}
          onAccountObject:
            objectType: DATABASE
            objectName: ${d.name}
          allPrivileges: true
          withGrantOption: true
      # list of privileges
      g5:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - MODIFY
            - CREATE TABLE
          roleName: ${r.name}
          onSchema:
            schemaName: '"my_db"."my_schema"'
      # all privileges + grant option
      g6:
        type: snowflake:GrantPrivilegesToRole
        properties:
          roleName: ${r.name}
          onSchema:
            schemaName: '"my_db"."my_schema"'
          allPrivileges: true
          withGrantOption: true
      # all schemas in database
      g7:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - MODIFY
            - CREATE TABLE
          roleName: ${r.name}
          onSchema:
            allSchemasInDatabase: ${d.name}
      # future schemas in database
      g8: ##################################
      ### schema object privileges
      ##################################
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - MODIFY
            - CREATE TABLE
          roleName: ${r.name}
          onSchema:
            futureSchemasInDatabase: ${d.name}
      # list of privileges
      g9:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - SELECT
            - REFERENCES
          roleName: ${r.name}
          onSchemaObject:
            objectType: VIEW
            objectName: '"my_db"."my_schema"."my_view"'
      # all privileges + grant option
      g10:
        type: snowflake:GrantPrivilegesToRole
        properties:
          roleName: ${r.name}
          onSchemaObject:
            objectType: VIEW
            objectName: '"my_db"."my_schema"."my_view"'
          allPrivileges: true
          withGrantOption: true
      # all in database
      g11:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - SELECT
            - INSERT
          roleName: ${r.name}
          onSchemaObject:
            all:
              objectTypePlural: TABLES
              inDatabase: ${d.name}
      # all in schema
      g12:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - SELECT
            - INSERT
          roleName: ${r.name}
          onSchemaObject:
            all:
              objectTypePlural: TABLES
              inSchema: '"my_db"."my_schema"'
      # future in database
      g13:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - SELECT
            - INSERT
          roleName: ${r.name}
          onSchemaObject:
            future:
              objectTypePlural: TABLES
              inDatabase: ${d.name}
      # future in schema
      g14:
        type: snowflake:GrantPrivilegesToRole
        properties:
          privileges:
            - SELECT
            - INSERT
          roleName: ${r.name}
          onSchemaObject:
            future:
              objectTypePlural: TABLES
              inSchema: '"my_db"."my_schema"'
    

    Create GrantPrivilegesToRole Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new GrantPrivilegesToRole(name: string, args: GrantPrivilegesToRoleArgs, opts?: CustomResourceOptions);
    @overload
    def GrantPrivilegesToRole(resource_name: str,
                              args: GrantPrivilegesToRoleArgs,
                              opts: Optional[ResourceOptions] = None)
    
    @overload
    def GrantPrivilegesToRole(resource_name: str,
                              opts: Optional[ResourceOptions] = None,
                              role_name: Optional[str] = None,
                              all_privileges: Optional[bool] = None,
                              on_account: Optional[bool] = None,
                              on_account_object: Optional[GrantPrivilegesToRoleOnAccountObjectArgs] = None,
                              on_schema: Optional[GrantPrivilegesToRoleOnSchemaArgs] = None,
                              on_schema_object: Optional[GrantPrivilegesToRoleOnSchemaObjectArgs] = None,
                              privileges: Optional[Sequence[str]] = None,
                              with_grant_option: Optional[bool] = None)
    func NewGrantPrivilegesToRole(ctx *Context, name string, args GrantPrivilegesToRoleArgs, opts ...ResourceOption) (*GrantPrivilegesToRole, error)
    public GrantPrivilegesToRole(string name, GrantPrivilegesToRoleArgs args, CustomResourceOptions? opts = null)
    public GrantPrivilegesToRole(String name, GrantPrivilegesToRoleArgs args)
    public GrantPrivilegesToRole(String name, GrantPrivilegesToRoleArgs args, CustomResourceOptions options)
    
    type: snowflake:GrantPrivilegesToRole
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args GrantPrivilegesToRoleArgs
    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 GrantPrivilegesToRoleArgs
    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 GrantPrivilegesToRoleArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args GrantPrivilegesToRoleArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args GrantPrivilegesToRoleArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var grantPrivilegesToRoleResource = new Snowflake.GrantPrivilegesToRole("grantPrivilegesToRoleResource", new()
    {
        RoleName = "string",
        AllPrivileges = false,
        OnAccount = false,
        OnAccountObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnAccountObjectArgs
        {
            ObjectName = "string",
            ObjectType = "string",
        },
        OnSchema = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaArgs
        {
            AllSchemasInDatabase = "string",
            FutureSchemasInDatabase = "string",
            SchemaName = "string",
        },
        OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectArgs
        {
            All = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectAllArgs
            {
                ObjectTypePlural = "string",
                InDatabase = "string",
                InSchema = "string",
            },
            Future = new Snowflake.Inputs.GrantPrivilegesToRoleOnSchemaObjectFutureArgs
            {
                ObjectTypePlural = "string",
                InDatabase = "string",
                InSchema = "string",
            },
            ObjectName = "string",
            ObjectType = "string",
        },
        Privileges = new[]
        {
            "string",
        },
        WithGrantOption = false,
    });
    
    example, err := snowflake.NewGrantPrivilegesToRole(ctx, "grantPrivilegesToRoleResource", &snowflake.GrantPrivilegesToRoleArgs{
    	RoleName:      pulumi.String("string"),
    	AllPrivileges: pulumi.Bool(false),
    	OnAccount:     pulumi.Bool(false),
    	OnAccountObject: &snowflake.GrantPrivilegesToRoleOnAccountObjectArgs{
    		ObjectName: pulumi.String("string"),
    		ObjectType: pulumi.String("string"),
    	},
    	OnSchema: &snowflake.GrantPrivilegesToRoleOnSchemaArgs{
    		AllSchemasInDatabase:    pulumi.String("string"),
    		FutureSchemasInDatabase: pulumi.String("string"),
    		SchemaName:              pulumi.String("string"),
    	},
    	OnSchemaObject: &snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs{
    		All: &snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs{
    			ObjectTypePlural: pulumi.String("string"),
    			InDatabase:       pulumi.String("string"),
    			InSchema:         pulumi.String("string"),
    		},
    		Future: &snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs{
    			ObjectTypePlural: pulumi.String("string"),
    			InDatabase:       pulumi.String("string"),
    			InSchema:         pulumi.String("string"),
    		},
    		ObjectName: pulumi.String("string"),
    		ObjectType: pulumi.String("string"),
    	},
    	Privileges: pulumi.StringArray{
    		pulumi.String("string"),
    	},
    	WithGrantOption: pulumi.Bool(false),
    })
    
    var grantPrivilegesToRoleResource = new GrantPrivilegesToRole("grantPrivilegesToRoleResource", GrantPrivilegesToRoleArgs.builder()
        .roleName("string")
        .allPrivileges(false)
        .onAccount(false)
        .onAccountObject(GrantPrivilegesToRoleOnAccountObjectArgs.builder()
            .objectName("string")
            .objectType("string")
            .build())
        .onSchema(GrantPrivilegesToRoleOnSchemaArgs.builder()
            .allSchemasInDatabase("string")
            .futureSchemasInDatabase("string")
            .schemaName("string")
            .build())
        .onSchemaObject(GrantPrivilegesToRoleOnSchemaObjectArgs.builder()
            .all(GrantPrivilegesToRoleOnSchemaObjectAllArgs.builder()
                .objectTypePlural("string")
                .inDatabase("string")
                .inSchema("string")
                .build())
            .future(GrantPrivilegesToRoleOnSchemaObjectFutureArgs.builder()
                .objectTypePlural("string")
                .inDatabase("string")
                .inSchema("string")
                .build())
            .objectName("string")
            .objectType("string")
            .build())
        .privileges("string")
        .withGrantOption(false)
        .build());
    
    grant_privileges_to_role_resource = snowflake.GrantPrivilegesToRole("grantPrivilegesToRoleResource",
        role_name="string",
        all_privileges=False,
        on_account=False,
        on_account_object=snowflake.GrantPrivilegesToRoleOnAccountObjectArgs(
            object_name="string",
            object_type="string",
        ),
        on_schema=snowflake.GrantPrivilegesToRoleOnSchemaArgs(
            all_schemas_in_database="string",
            future_schemas_in_database="string",
            schema_name="string",
        ),
        on_schema_object=snowflake.GrantPrivilegesToRoleOnSchemaObjectArgs(
            all=snowflake.GrantPrivilegesToRoleOnSchemaObjectAllArgs(
                object_type_plural="string",
                in_database="string",
                in_schema="string",
            ),
            future=snowflake.GrantPrivilegesToRoleOnSchemaObjectFutureArgs(
                object_type_plural="string",
                in_database="string",
                in_schema="string",
            ),
            object_name="string",
            object_type="string",
        ),
        privileges=["string"],
        with_grant_option=False)
    
    const grantPrivilegesToRoleResource = new snowflake.GrantPrivilegesToRole("grantPrivilegesToRoleResource", {
        roleName: "string",
        allPrivileges: false,
        onAccount: false,
        onAccountObject: {
            objectName: "string",
            objectType: "string",
        },
        onSchema: {
            allSchemasInDatabase: "string",
            futureSchemasInDatabase: "string",
            schemaName: "string",
        },
        onSchemaObject: {
            all: {
                objectTypePlural: "string",
                inDatabase: "string",
                inSchema: "string",
            },
            future: {
                objectTypePlural: "string",
                inDatabase: "string",
                inSchema: "string",
            },
            objectName: "string",
            objectType: "string",
        },
        privileges: ["string"],
        withGrantOption: false,
    });
    
    type: snowflake:GrantPrivilegesToRole
    properties:
        allPrivileges: false
        onAccount: false
        onAccountObject:
            objectName: string
            objectType: string
        onSchema:
            allSchemasInDatabase: string
            futureSchemasInDatabase: string
            schemaName: string
        onSchemaObject:
            all:
                inDatabase: string
                inSchema: string
                objectTypePlural: string
            future:
                inDatabase: string
                inSchema: string
                objectTypePlural: string
            objectName: string
            objectType: string
        privileges:
            - string
        roleName: string
        withGrantOption: false
    

    GrantPrivilegesToRole 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 GrantPrivilegesToRole resource accepts the following input properties:

    RoleName string
    The fully qualified name of the role to which privileges will be granted.
    AllPrivileges bool
    Grant all privileges on the account role.
    OnAccount bool
    If true, the privileges will be granted on the account.
    OnAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    OnSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    Privileges List<string>
    The privileges to grant on the account role.
    WithGrantOption bool
    Specifies whether the grantee can grant the privileges to other users.
    RoleName string
    The fully qualified name of the role to which privileges will be granted.
    AllPrivileges bool
    Grant all privileges on the account role.
    OnAccount bool
    If true, the privileges will be granted on the account.
    OnAccountObject GrantPrivilegesToRoleOnAccountObjectArgs
    Specifies the account object on which privileges will be granted
    OnSchema GrantPrivilegesToRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    Privileges []string
    The privileges to grant on the account role.
    WithGrantOption bool
    Specifies whether the grantee can grant the privileges to other users.
    roleName String
    The fully qualified name of the role to which privileges will be granted.
    allPrivileges Boolean
    Grant all privileges on the account role.
    onAccount Boolean
    If true, the privileges will be granted on the account.
    onAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    onSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the account role.
    withGrantOption Boolean
    Specifies whether the grantee can grant the privileges to other users.
    roleName string
    The fully qualified name of the role to which privileges will be granted.
    allPrivileges boolean
    Grant all privileges on the account role.
    onAccount boolean
    If true, the privileges will be granted on the account.
    onAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    onSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges string[]
    The privileges to grant on the account role.
    withGrantOption boolean
    Specifies whether the grantee can grant the privileges to other users.
    role_name str
    The fully qualified name of the role to which privileges will be granted.
    all_privileges bool
    Grant all privileges on the account role.
    on_account bool
    If true, the privileges will be granted on the account.
    on_account_object GrantPrivilegesToRoleOnAccountObjectArgs
    Specifies the account object on which privileges will be granted
    on_schema GrantPrivilegesToRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    on_schema_object GrantPrivilegesToRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    privileges Sequence[str]
    The privileges to grant on the account role.
    with_grant_option bool
    Specifies whether the grantee can grant the privileges to other users.
    roleName String
    The fully qualified name of the role to which privileges will be granted.
    allPrivileges Boolean
    Grant all privileges on the account role.
    onAccount Boolean
    If true, the privileges will be granted on the account.
    onAccountObject Property Map
    Specifies the account object on which privileges will be granted
    onSchema Property Map
    Specifies the schema on which privileges will be granted.
    onSchemaObject Property Map
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the account role.
    withGrantOption Boolean
    Specifies whether the grantee can grant the privileges to other users.

    Outputs

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

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing GrantPrivilegesToRole Resource

    Get an existing GrantPrivilegesToRole resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: GrantPrivilegesToRoleState, opts?: CustomResourceOptions): GrantPrivilegesToRole
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            all_privileges: Optional[bool] = None,
            on_account: Optional[bool] = None,
            on_account_object: Optional[GrantPrivilegesToRoleOnAccountObjectArgs] = None,
            on_schema: Optional[GrantPrivilegesToRoleOnSchemaArgs] = None,
            on_schema_object: Optional[GrantPrivilegesToRoleOnSchemaObjectArgs] = None,
            privileges: Optional[Sequence[str]] = None,
            role_name: Optional[str] = None,
            with_grant_option: Optional[bool] = None) -> GrantPrivilegesToRole
    func GetGrantPrivilegesToRole(ctx *Context, name string, id IDInput, state *GrantPrivilegesToRoleState, opts ...ResourceOption) (*GrantPrivilegesToRole, error)
    public static GrantPrivilegesToRole Get(string name, Input<string> id, GrantPrivilegesToRoleState? state, CustomResourceOptions? opts = null)
    public static GrantPrivilegesToRole get(String name, Output<String> id, GrantPrivilegesToRoleState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AllPrivileges bool
    Grant all privileges on the account role.
    OnAccount bool
    If true, the privileges will be granted on the account.
    OnAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    OnSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    Privileges List<string>
    The privileges to grant on the account role.
    RoleName string
    The fully qualified name of the role to which privileges will be granted.
    WithGrantOption bool
    Specifies whether the grantee can grant the privileges to other users.
    AllPrivileges bool
    Grant all privileges on the account role.
    OnAccount bool
    If true, the privileges will be granted on the account.
    OnAccountObject GrantPrivilegesToRoleOnAccountObjectArgs
    Specifies the account object on which privileges will be granted
    OnSchema GrantPrivilegesToRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    Privileges []string
    The privileges to grant on the account role.
    RoleName string
    The fully qualified name of the role to which privileges will be granted.
    WithGrantOption bool
    Specifies whether the grantee can grant the privileges to other users.
    allPrivileges Boolean
    Grant all privileges on the account role.
    onAccount Boolean
    If true, the privileges will be granted on the account.
    onAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    onSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the account role.
    roleName String
    The fully qualified name of the role to which privileges will be granted.
    withGrantOption Boolean
    Specifies whether the grantee can grant the privileges to other users.
    allPrivileges boolean
    Grant all privileges on the account role.
    onAccount boolean
    If true, the privileges will be granted on the account.
    onAccountObject GrantPrivilegesToRoleOnAccountObject
    Specifies the account object on which privileges will be granted
    onSchema GrantPrivilegesToRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges string[]
    The privileges to grant on the account role.
    roleName string
    The fully qualified name of the role to which privileges will be granted.
    withGrantOption boolean
    Specifies whether the grantee can grant the privileges to other users.
    all_privileges bool
    Grant all privileges on the account role.
    on_account bool
    If true, the privileges will be granted on the account.
    on_account_object GrantPrivilegesToRoleOnAccountObjectArgs
    Specifies the account object on which privileges will be granted
    on_schema GrantPrivilegesToRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    on_schema_object GrantPrivilegesToRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    privileges Sequence[str]
    The privileges to grant on the account role.
    role_name str
    The fully qualified name of the role to which privileges will be granted.
    with_grant_option bool
    Specifies whether the grantee can grant the privileges to other users.
    allPrivileges Boolean
    Grant all privileges on the account role.
    onAccount Boolean
    If true, the privileges will be granted on the account.
    onAccountObject Property Map
    Specifies the account object on which privileges will be granted
    onSchema Property Map
    Specifies the schema on which privileges will be granted.
    onSchemaObject Property Map
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the account role.
    roleName String
    The fully qualified name of the role to which privileges will be granted.
    withGrantOption Boolean
    Specifies whether the grantee can grant the privileges to other users.

    Supporting Types

    GrantPrivilegesToRoleOnAccountObject, GrantPrivilegesToRoleOnAccountObjectArgs

    ObjectName string
    The fully qualified name of the object on which privileges will be granted.
    ObjectType string
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME
    ObjectName string
    The fully qualified name of the object on which privileges will be granted.
    ObjectType string
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME
    objectName String
    The fully qualified name of the object on which privileges will be granted.
    objectType String
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME
    objectName string
    The fully qualified name of the object on which privileges will be granted.
    objectType string
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME
    object_name str
    The fully qualified name of the object on which privileges will be granted.
    object_type str
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME
    objectName String
    The fully qualified name of the object on which privileges will be granted.
    objectType String
    The object type of the account object on which privileges will be granted. Valid values are: USER | RESOURCE MONITOR | WAREHOUSE | DATABASE | INTEGRATION | FAILOVER GROUP | REPLICATION GROUP | EXTERNAL VOLUME

    GrantPrivilegesToRoleOnSchema, GrantPrivilegesToRoleOnSchemaArgs

    AllSchemasInDatabase string
    The fully qualified name of the database.
    FutureSchemasInDatabase string
    The fully qualified name of the database.
    SchemaName string
    The fully qualified name of the schema.
    AllSchemasInDatabase string
    The fully qualified name of the database.
    FutureSchemasInDatabase string
    The fully qualified name of the database.
    SchemaName string
    The fully qualified name of the schema.
    allSchemasInDatabase String
    The fully qualified name of the database.
    futureSchemasInDatabase String
    The fully qualified name of the database.
    schemaName String
    The fully qualified name of the schema.
    allSchemasInDatabase string
    The fully qualified name of the database.
    futureSchemasInDatabase string
    The fully qualified name of the database.
    schemaName string
    The fully qualified name of the schema.
    all_schemas_in_database str
    The fully qualified name of the database.
    future_schemas_in_database str
    The fully qualified name of the database.
    schema_name str
    The fully qualified name of the schema.
    allSchemasInDatabase String
    The fully qualified name of the database.
    futureSchemasInDatabase String
    The fully qualified name of the database.
    schemaName String
    The fully qualified name of the schema.

    GrantPrivilegesToRoleOnSchemaObject, GrantPrivilegesToRoleOnSchemaObjectArgs

    All GrantPrivilegesToRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in eihter a database or schema.
    Future GrantPrivilegesToRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in eihter a database or schema.
    ObjectName string
    The fully qualified name of the object on which privileges will be granted.
    ObjectType string
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT
    All GrantPrivilegesToRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in eihter a database or schema.
    Future GrantPrivilegesToRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in eihter a database or schema.
    ObjectName string
    The fully qualified name of the object on which privileges will be granted.
    ObjectType string
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT
    all GrantPrivilegesToRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in eihter a database or schema.
    future GrantPrivilegesToRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in eihter a database or schema.
    objectName String
    The fully qualified name of the object on which privileges will be granted.
    objectType String
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT
    all GrantPrivilegesToRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in eihter a database or schema.
    future GrantPrivilegesToRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in eihter a database or schema.
    objectName string
    The fully qualified name of the object on which privileges will be granted.
    objectType string
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT
    all GrantPrivilegesToRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in eihter a database or schema.
    future GrantPrivilegesToRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in eihter a database or schema.
    object_name str
    The fully qualified name of the object on which privileges will be granted.
    object_type str
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT
    all Property Map
    Configures the privilege to be granted on all objects in eihter a database or schema.
    future Property Map
    Configures the privilege to be granted on future objects in eihter a database or schema.
    objectName String
    The fully qualified name of the object on which privileges will be granted.
    objectType String
    The object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | DATA METRIC FUNCTION | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | IMAGE REPOSITORY | ICEBERG TABLE | MASKING POLICY | MATERIALIZED VIEW | MODEL | NETWORK RULE | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT

    GrantPrivilegesToRoleOnSchemaObjectAll, GrantPrivilegesToRoleOnSchemaObjectAllArgs

    ObjectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    InDatabase string
    The fully qualified name of the database.
    InSchema string
    The fully qualified name of the schema.
    ObjectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    InDatabase string
    The fully qualified name of the database.
    InSchema string
    The fully qualified name of the schema.
    objectTypePlural String
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.
    objectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    inDatabase string
    The fully qualified name of the database.
    inSchema string
    The fully qualified name of the schema.
    object_type_plural str
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    in_database str
    The fully qualified name of the database.
    in_schema str
    The fully qualified name of the schema.
    objectTypePlural String
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | IMAGE REPOSITORIES | ICEBERG TABLES | MASKING POLICIES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.

    GrantPrivilegesToRoleOnSchemaObjectFuture, GrantPrivilegesToRoleOnSchemaObjectFutureArgs

    ObjectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    InDatabase string
    The fully qualified name of the database.
    InSchema string
    The fully qualified name of the schema.
    ObjectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    InDatabase string
    The fully qualified name of the database.
    InSchema string
    The fully qualified name of the schema.
    objectTypePlural String
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.
    objectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    inDatabase string
    The fully qualified name of the database.
    inSchema string
    The fully qualified name of the schema.
    object_type_plural str
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    in_database str
    The fully qualified name of the database.
    in_schema str
    The fully qualified name of the schema.
    objectTypePlural String
    The plural object type of the schema object on which privileges will be granted. Valid values are: ALERTS | AUTHENTICATION POLICIES | DATA METRIC FUNCTIONS | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | MATERIALIZED VIEWS | MODELS | NETWORK RULES | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | STAGES | STREAMS | TABLES | TASKS | VIEWS
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.

    Import

    format is role_name (string) | privileges (comma-delimited string) | all_privileges (bool) |with_grant_option (bool) | on_account (bool) | on_account_object (bool) | on_schema (bool) | on_schema_object (bool) | all (bool) | future (bool) | object_type (string) | object_name (string) | object_type_plural (string) | in_schema (bool) | schema_name (string) | in_database (bool) | database_name (string)

    $ pulumi import snowflake:index/grantPrivilegesToRole:GrantPrivilegesToRole "test_role|MANAGE GRANTS,MONITOR USAGE|false|false|true|false|false|false|false|false||||false||false|"
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi