snowflake.getGrants

import pulumi
import pulumi_snowflake as snowflake

##################################
### SHOW GRANTS ON ...
##################################
# account
example_on_account = snowflake.get_grants(grants_on={
    "account": True,
})
# account object (e.g. database)
example_on_account_object = snowflake.get_grants(grants_on={
    "object_name": "some_database",
    "object_type": "DATABASE",
})
# database object (e.g. schema)
example_on_database_object = snowflake.get_grants(grants_on={
    "object_name": "\"some_database\".\"some_schema\"",
    "object_type": "SCHEMA",
})
# schema object (e.g. table)
example_on_schema_object = snowflake.get_grants(grants_on={
    "object_name": "\"some_database\".\"some_schema\".\"some_table\"",
    "object_type": "TABLE",
})
# application
example_to_application = snowflake.get_grants(grants_to={
    "application": "some_application",
})
# application role
example_to_application_role = snowflake.get_grants(grants_to={
    "application_role": "\"some_application\".\"some_application_role\"",
})
# account role
example_to_role = snowflake.get_grants(grants_to={
    "account_role": "some_role",
})
# database role
example_to_database_role = snowflake.get_grants(grants_to={
    "database_role": "\"some_database\".\"some_database_role\"",
})
# share
example_to_share = snowflake.get_grants(grants_to={
    "share": {
        "share_name": "some_share",
    },
})
# user
example_to_user = snowflake.get_grants(grants_to={
    "user": "some_user",
})
# application role
example_of_application_role = snowflake.get_grants(grants_of={
    "application_role": "\"some_application\".\"some_application_role\"",
})
# database role
example_of_database_role = snowflake.get_grants(grants_of={
    "database_role": "\"some_database\".\"some_database_role\"",
})
# account role
example_of_role = snowflake.get_grants(grants_of={
    "account_role": "some_role",
})
# share
example_of_share = snowflake.get_grants(grants_of={
    "share": "some_share",
})
# database
example_future_in_database = snowflake.get_grants(future_grants_in={
    "database": "some_database",
})
# schema
example_future_in_schema = snowflake.get_grants(future_grants_in={
    "schema": "\"some_database\".\"some_schema\"",
})
# account role
example_future_to_role = snowflake.get_grants(future_grants_to={
    "account_role": "some_role",
})
# database role
example_future_to_database_role = snowflake.get_grants(future_grants_to={
    "database_role": "\"some_database\".\"some_database_role\"",
})

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 {
		// #################################
		// ## SHOW GRANTS ON ...
		// #################################
		// account
		_, err := snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOn: snowflake.GetGrantsGrantsOn{
				Account: pulumi.BoolRef(true),
			},
		}, nil)
		if err != nil {
			return err
		}
		// account object (e.g. database)
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOn: snowflake.GetGrantsGrantsOn{
				ObjectName: pulumi.StringRef("some_database"),
				ObjectType: pulumi.StringRef("DATABASE"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// database object (e.g. schema)
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOn: snowflake.GetGrantsGrantsOn{
				ObjectName: pulumi.StringRef("\"some_database\".\"some_schema\""),
				ObjectType: pulumi.StringRef("SCHEMA"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// schema object (e.g. table)
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOn: snowflake.GetGrantsGrantsOn{
				ObjectName: pulumi.StringRef("\"some_database\".\"some_schema\".\"some_table\""),
				ObjectType: pulumi.StringRef("TABLE"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// application
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				Application: pulumi.StringRef("some_application"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// application role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				ApplicationRole: pulumi.StringRef("\"some_application\".\"some_application_role\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		// account role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				AccountRole: pulumi.StringRef("some_role"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// database role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				DatabaseRole: pulumi.StringRef("\"some_database\".\"some_database_role\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		// share
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				Share: snowflake.GetGrantsGrantsToShare{
					ShareName: "some_share",
				},
			},
		}, nil)
		if err != nil {
			return err
		}
		// user
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsTo: snowflake.GetGrantsGrantsTo{
				User: pulumi.StringRef("some_user"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// application role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOf: snowflake.GetGrantsGrantsOf{
				ApplicationRole: pulumi.StringRef("\"some_application\".\"some_application_role\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		// database role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOf: snowflake.GetGrantsGrantsOf{
				DatabaseRole: pulumi.StringRef("\"some_database\".\"some_database_role\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		// account role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOf: snowflake.GetGrantsGrantsOf{
				AccountRole: pulumi.StringRef("some_role"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// share
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			GrantsOf: snowflake.GetGrantsGrantsOf{
				Share: pulumi.StringRef("some_share"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// database
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			FutureGrantsIn: snowflake.GetGrantsFutureGrantsIn{
				Database: pulumi.StringRef("some_database"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// schema
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			FutureGrantsIn: snowflake.GetGrantsFutureGrantsIn{
				Schema: pulumi.StringRef("\"some_database\".\"some_schema\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		// account role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			FutureGrantsTo: snowflake.GetGrantsFutureGrantsTo{
				AccountRole: pulumi.StringRef("some_role"),
			},
		}, nil)
		if err != nil {
			return err
		}
		// database role
		_, err = snowflake.GetGrants(ctx, &snowflake.GetGrantsArgs{
			FutureGrantsTo: snowflake.GetGrantsFutureGrantsTo{
				DatabaseRole: pulumi.StringRef("\"some_database\".\"some_database_role\""),
			},
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    //#################################
    //## SHOW GRANTS ON ...
    //#################################
    // account
    var exampleOnAccount = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOn = new Snowflake.Inputs.GetGrantsGrantsOnInputArgs
        {
            Account = true,
        },
    });

    // account object (e.g. database)
    var exampleOnAccountObject = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOn = new Snowflake.Inputs.GetGrantsGrantsOnInputArgs
        {
            ObjectName = "some_database",
            ObjectType = "DATABASE",
        },
    });

    // database object (e.g. schema)
    var exampleOnDatabaseObject = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOn = new Snowflake.Inputs.GetGrantsGrantsOnInputArgs
        {
            ObjectName = "\"some_database\".\"some_schema\"",
            ObjectType = "SCHEMA",
        },
    });

    // schema object (e.g. table)
    var exampleOnSchemaObject = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOn = new Snowflake.Inputs.GetGrantsGrantsOnInputArgs
        {
            ObjectName = "\"some_database\".\"some_schema\".\"some_table\"",
            ObjectType = "TABLE",
        },
    });

    // application
    var exampleToApplication = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            Application = "some_application",
        },
    });

    // application role
    var exampleToApplicationRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            ApplicationRole = "\"some_application\".\"some_application_role\"",
        },
    });

    // account role
    var exampleToRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            AccountRole = "some_role",
        },
    });

    // database role
    var exampleToDatabaseRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            DatabaseRole = "\"some_database\".\"some_database_role\"",
        },
    });

    // share
    var exampleToShare = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            Share = new Snowflake.Inputs.GetGrantsGrantsToShareInputArgs
            {
                ShareName = "some_share",
            },
        },
    });

    // user
    var exampleToUser = Snowflake.GetGrants.Invoke(new()
    {
        GrantsTo = new Snowflake.Inputs.GetGrantsGrantsToInputArgs
        {
            User = "some_user",
        },
    });

    // application role
    var exampleOfApplicationRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOf = new Snowflake.Inputs.GetGrantsGrantsOfInputArgs
        {
            ApplicationRole = "\"some_application\".\"some_application_role\"",
        },
    });

    // database role
    var exampleOfDatabaseRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOf = new Snowflake.Inputs.GetGrantsGrantsOfInputArgs
        {
            DatabaseRole = "\"some_database\".\"some_database_role\"",
        },
    });

    // account role
    var exampleOfRole = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOf = new Snowflake.Inputs.GetGrantsGrantsOfInputArgs
        {
            AccountRole = "some_role",
        },
    });

    // share
    var exampleOfShare = Snowflake.GetGrants.Invoke(new()
    {
        GrantsOf = new Snowflake.Inputs.GetGrantsGrantsOfInputArgs
        {
            Share = "some_share",
        },
    });

    // database
    var exampleFutureInDatabase = Snowflake.GetGrants.Invoke(new()
    {
        FutureGrantsIn = new Snowflake.Inputs.GetGrantsFutureGrantsInInputArgs
        {
            Database = "some_database",
        },
    });

    // schema
    var exampleFutureInSchema = Snowflake.GetGrants.Invoke(new()
    {
        FutureGrantsIn = new Snowflake.Inputs.GetGrantsFutureGrantsInInputArgs
        {
            Schema = "\"some_database\".\"some_schema\"",
        },
    });

    // account role
    var exampleFutureToRole = Snowflake.GetGrants.Invoke(new()
    {
        FutureGrantsTo = new Snowflake.Inputs.GetGrantsFutureGrantsToInputArgs
        {
            AccountRole = "some_role",
        },
    });

    // database role
    var exampleFutureToDatabaseRole = Snowflake.GetGrants.Invoke(new()
    {
        FutureGrantsTo = new Snowflake.Inputs.GetGrantsFutureGrantsToInputArgs
        {
            DatabaseRole = "\"some_database\".\"some_database_role\"",
        },
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.SnowflakeFunctions;
import com.pulumi.snowflake.inputs.GetGrantsArgs;
import com.pulumi.snowflake.inputs.GetGrantsGrantsOnArgs;
import com.pulumi.snowflake.inputs.GetGrantsGrantsToArgs;
import com.pulumi.snowflake.inputs.GetGrantsGrantsToShareArgs;
import com.pulumi.snowflake.inputs.GetGrantsGrantsOfArgs;
import com.pulumi.snowflake.inputs.GetGrantsFutureGrantsInArgs;
import com.pulumi.snowflake.inputs.GetGrantsFutureGrantsToArgs;
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) {
        //#################################
        //## SHOW GRANTS ON ...
        //#################################
        // account
        final var exampleOnAccount = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOn(GetGrantsGrantsOnArgs.builder()
                .account(true)
                .build())
            .build());

        // account object (e.g. database)
        final var exampleOnAccountObject = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOn(GetGrantsGrantsOnArgs.builder()
                .objectName("some_database")
                .objectType("DATABASE")
                .build())
            .build());

        // database object (e.g. schema)
        final var exampleOnDatabaseObject = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOn(GetGrantsGrantsOnArgs.builder()
                .objectName("\"some_database\".\"some_schema\"")
                .objectType("SCHEMA")
                .build())
            .build());

        // schema object (e.g. table)
        final var exampleOnSchemaObject = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOn(GetGrantsGrantsOnArgs.builder()
                .objectName("\"some_database\".\"some_schema\".\"some_table\"")
                .objectType("TABLE")
                .build())
            .build());

        // application
        final var exampleToApplication = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .application("some_application")
                .build())
            .build());

        // application role
        final var exampleToApplicationRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .applicationRole("\"some_application\".\"some_application_role\"")
                .build())
            .build());

        // account role
        final var exampleToRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .accountRole("some_role")
                .build())
            .build());

        // database role
        final var exampleToDatabaseRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .databaseRole("\"some_database\".\"some_database_role\"")
                .build())
            .build());

        // share
        final var exampleToShare = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .share(GetGrantsGrantsToShareArgs.builder()
                    .shareName("some_share")
                    .build())
                .build())
            .build());

        // user
        final var exampleToUser = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsTo(GetGrantsGrantsToArgs.builder()
                .user("some_user")
                .build())
            .build());

        // application role
        final var exampleOfApplicationRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOf(GetGrantsGrantsOfArgs.builder()
                .applicationRole("\"some_application\".\"some_application_role\"")
                .build())
            .build());

        // database role
        final var exampleOfDatabaseRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOf(GetGrantsGrantsOfArgs.builder()
                .databaseRole("\"some_database\".\"some_database_role\"")
                .build())
            .build());

        // account role
        final var exampleOfRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOf(GetGrantsGrantsOfArgs.builder()
                .accountRole("some_role")
                .build())
            .build());

        // share
        final var exampleOfShare = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .grantsOf(GetGrantsGrantsOfArgs.builder()
                .share("some_share")
                .build())
            .build());

        // database
        final var exampleFutureInDatabase = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .futureGrantsIn(GetGrantsFutureGrantsInArgs.builder()
                .database("some_database")
                .build())
            .build());

        // schema
        final var exampleFutureInSchema = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .futureGrantsIn(GetGrantsFutureGrantsInArgs.builder()
                .schema("\"some_database\".\"some_schema\"")
                .build())
            .build());

        // account role
        final var exampleFutureToRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .futureGrantsTo(GetGrantsFutureGrantsToArgs.builder()
                .accountRole("some_role")
                .build())
            .build());

        // database role
        final var exampleFutureToDatabaseRole = SnowflakeFunctions.getGrants(GetGrantsArgs.builder()
            .futureGrantsTo(GetGrantsFutureGrantsToArgs.builder()
                .databaseRole("\"some_database\".\"some_database_role\"")
                .build())
            .build());

    }
}

variables:
  ##################################
  ### SHOW GRANTS ON ...
  ##################################

  # account
  exampleOnAccount:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOn:
          account: true
  # account object (e.g. database)
  exampleOnAccountObject:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOn:
          objectName: some_database
          objectType: DATABASE
  # database object (e.g. schema)
  exampleOnDatabaseObject:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOn:
          objectName: '"some_database"."some_schema"'
          objectType: SCHEMA
  # schema object (e.g. table)
  exampleOnSchemaObject: ##################################
  ### SHOW GRANTS TO ...
  ##################################
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOn:
          objectName: '"some_database"."some_schema"."some_table"'
          objectType: TABLE
  # application
  exampleToApplication:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          application: some_application
  # application role
  exampleToApplicationRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          applicationRole: '"some_application"."some_application_role"'
  # account role
  exampleToRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          accountRole: some_role
  # database role
  exampleToDatabaseRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          databaseRole: '"some_database"."some_database_role"'
  # share
  exampleToShare:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          share:
            shareName: some_share
  # user
  exampleToUser: ##################################
  ### SHOW GRANTS OF ...
  ##################################
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsTo:
          user: some_user
  # application role
  exampleOfApplicationRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOf:
          applicationRole: '"some_application"."some_application_role"'
  # database role
  exampleOfDatabaseRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOf:
          databaseRole: '"some_database"."some_database_role"'
  # account role
  exampleOfRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOf:
          accountRole: some_role
  # share
  exampleOfShare: ##################################
  ### SHOW FUTURE GRANTS IN ...
  ##################################
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        grantsOf:
          share: some_share
  # database
  exampleFutureInDatabase:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        futureGrantsIn:
          database: some_database
  # schema
  exampleFutureInSchema: ##################################
  ### SHOW FUTURE GRANTS TO ...
  ##################################
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        futureGrantsIn:
          schema: '"some_database"."some_schema"'
  # account role
  exampleFutureToRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        futureGrantsTo:
          accountRole: some_role
  # database role
  exampleFutureToDatabaseRole:
    fn::invoke:
      function: snowflake:getGrants
      arguments:
        futureGrantsTo:
          databaseRole: '"some_database"."some_database_role"'

def get_grants(future_grants_in: Optional[GetGrantsFutureGrantsIn] = None,
               future_grants_to: Optional[GetGrantsFutureGrantsTo] = None,
               grants_of: Optional[GetGrantsGrantsOf] = None,
               grants_on: Optional[GetGrantsGrantsOn] = None,
               grants_to: Optional[GetGrantsGrantsTo] = None,
               opts: Optional[InvokeOptions] = None) -> GetGrantsResult
def get_grants_output(future_grants_in: Optional[pulumi.Input[GetGrantsFutureGrantsInArgs]] = None,
               future_grants_to: Optional[pulumi.Input[GetGrantsFutureGrantsToArgs]] = None,
               grants_of: Optional[pulumi.Input[GetGrantsGrantsOfArgs]] = None,
               grants_on: Optional[pulumi.Input[GetGrantsGrantsOnArgs]] = None,
               grants_to: Optional[pulumi.Input[GetGrantsGrantsToArgs]] = None,
               opts: Optional[InvokeOptions] = None) -> Output[GetGrantsResult]

func GetGrants(ctx *Context, args *GetGrantsArgs, opts ...InvokeOption) (*GetGrantsResult, error)
func GetGrantsOutput(ctx *Context, args *GetGrantsOutputArgs, opts ...InvokeOption) GetGrantsResultOutput

public static class GetGrants 
{
    public static Task<GetGrantsResult> InvokeAsync(GetGrantsArgs args, InvokeOptions? opts = null)
    public static Output<GetGrantsResult> Invoke(GetGrantsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetGrantsResult> getGrants(GetGrantsArgs args, InvokeOptions options)
public static Output<GetGrantsResult> getGrants(GetGrantsArgs args, InvokeOptions options)

fn::invoke:
  function: snowflake:index/getGrants:getGrants
  arguments:
    # arguments dictionary