Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Snowflake Provider
  3. API Docs
  4. GrantPrivilegesToDatabaseRole
Snowflake v0.61.1 published on Thursday, Nov 14, 2024 by Pulumi
pulumi/pulumi-snowflake

snowflake.GrantPrivilegesToDatabaseRole

Explore with Pulumi AI

snowflake logo
Snowflake v0.61.1 published on Thursday, Nov 14, 2024 by Pulumi
pulumi/pulumi-snowflake

    Import

    Import examples

    Grant all privileges OnDatabase

    $ pulumi import snowflake:index/grantPrivilegesToDatabaseRole:GrantPrivilegesToDatabaseRole example '"test_db"."test_db_role"|false|false|ALL|OnDatabase|"test_db"'`

    Grant list of privileges OnAllSchemasInDatabase

    $ pulumi import snowflake:index/grantPrivilegesToDatabaseRole:GrantPrivilegesToDatabaseRole example '"test_db"."test_db_role"|false|false|CREATE TAG,CREATE TABLE|OnSchema|OnAllSchemasInDatabase|"test_db"'`

    Grant list of privileges on table

    $ pulumi import snowflake:index/grantPrivilegesToDatabaseRole:GrantPrivilegesToDatabaseRole example '"test_db"."test_db_role"|false|false|SELECT,DELETE,INSERT|OnSchemaObject|OnObject|TABLE|"test_db"."test_schema"."test_table"'`

    Grant list of privileges OnAll tables in schema

    $ pulumi import snowflake:index/grantPrivilegesToDatabaseRole:GrantPrivilegesToDatabaseRole example '"test_db"."test_db_role"|false|false|SELECT,DELETE,INSERT|OnSchemaObject|OnAll|TABLES|InSchema|"test_db"."test_schema"'`

    Create GrantPrivilegesToDatabaseRole Resource

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

    Constructor syntax

    new GrantPrivilegesToDatabaseRole(name: string, args: GrantPrivilegesToDatabaseRoleArgs, opts?: CustomResourceOptions);
    @overload
def GrantPrivilegesToDatabaseRole(resource_name: str,
                                  args: GrantPrivilegesToDatabaseRoleArgs,
                                  opts: Optional[ResourceOptions] = None)

@overload
def GrantPrivilegesToDatabaseRole(resource_name: str,
                                  opts: Optional[ResourceOptions] = None,
                                  database_role_name: Optional[str] = None,
                                  all_privileges: Optional[bool] = None,
                                  always_apply: Optional[bool] = None,
                                  always_apply_trigger: Optional[str] = None,
                                  on_database: Optional[str] = None,
                                  on_schema: Optional[GrantPrivilegesToDatabaseRoleOnSchemaArgs] = None,
                                  on_schema_object: Optional[GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs] = None,
                                  privileges: Optional[Sequence[str]] = None,
                                  with_grant_option: Optional[bool] = None)
    func NewGrantPrivilegesToDatabaseRole(ctx *Context, name string, args GrantPrivilegesToDatabaseRoleArgs, opts ...ResourceOption) (*GrantPrivilegesToDatabaseRole, error)
    public GrantPrivilegesToDatabaseRole(string name, GrantPrivilegesToDatabaseRoleArgs args, CustomResourceOptions? opts = null)
    public GrantPrivilegesToDatabaseRole(String name, GrantPrivilegesToDatabaseRoleArgs args)
public GrantPrivilegesToDatabaseRole(String name, GrantPrivilegesToDatabaseRoleArgs args, CustomResourceOptions options)

    type: snowflake:GrantPrivilegesToDatabaseRole
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 GrantPrivilegesToDatabaseRoleArgs
    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 GrantPrivilegesToDatabaseRoleArgs
    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 GrantPrivilegesToDatabaseRoleArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args GrantPrivilegesToDatabaseRoleArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args GrantPrivilegesToDatabaseRoleArgs
    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 grantPrivilegesToDatabaseRoleResource = new Snowflake.GrantPrivilegesToDatabaseRole("grantPrivilegesToDatabaseRoleResource", new()
{
    DatabaseRoleName = "string",
    AllPrivileges = false,
    AlwaysApply = false,
    AlwaysApplyTrigger = "string",
    OnDatabase = "string",
    OnSchema = new Snowflake.Inputs.GrantPrivilegesToDatabaseRoleOnSchemaArgs
    {
        AllSchemasInDatabase = "string",
        FutureSchemasInDatabase = "string",
        SchemaName = "string",
    },
    OnSchemaObject = new Snowflake.Inputs.GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs
    {
        All = new Snowflake.Inputs.GrantPrivilegesToDatabaseRoleOnSchemaObjectAllArgs
        {
            ObjectTypePlural = "string",
            InDatabase = "string",
            InSchema = "string",
        },
        Future = new Snowflake.Inputs.GrantPrivilegesToDatabaseRoleOnSchemaObjectFutureArgs
        {
            ObjectTypePlural = "string",
            InDatabase = "string",
            InSchema = "string",
        },
        ObjectName = "string",
        ObjectType = "string",
    },
    Privileges = new[]
    {
        "string",
    },
    WithGrantOption = false,
});

    example, err := snowflake.NewGrantPrivilegesToDatabaseRole(ctx, "grantPrivilegesToDatabaseRoleResource", &snowflake.GrantPrivilegesToDatabaseRoleArgs{
	DatabaseRoleName:   pulumi.String("string"),
	AllPrivileges:      pulumi.Bool(false),
	AlwaysApply:        pulumi.Bool(false),
	AlwaysApplyTrigger: pulumi.String("string"),
	OnDatabase:         pulumi.String("string"),
	OnSchema: &snowflake.GrantPrivilegesToDatabaseRoleOnSchemaArgs{
		AllSchemasInDatabase:    pulumi.String("string"),
		FutureSchemasInDatabase: pulumi.String("string"),
		SchemaName:              pulumi.String("string"),
	},
	OnSchemaObject: &snowflake.GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs{
		All: &snowflake.GrantPrivilegesToDatabaseRoleOnSchemaObjectAllArgs{
			ObjectTypePlural: pulumi.String("string"),
			InDatabase:       pulumi.String("string"),
			InSchema:         pulumi.String("string"),
		},
		Future: &snowflake.GrantPrivilegesToDatabaseRoleOnSchemaObjectFutureArgs{
			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 grantPrivilegesToDatabaseRoleResource = new GrantPrivilegesToDatabaseRole("grantPrivilegesToDatabaseRoleResource", GrantPrivilegesToDatabaseRoleArgs.builder()
    .databaseRoleName("string")
    .allPrivileges(false)
    .alwaysApply(false)
    .alwaysApplyTrigger("string")
    .onDatabase("string")
    .onSchema(GrantPrivilegesToDatabaseRoleOnSchemaArgs.builder()
        .allSchemasInDatabase("string")
        .futureSchemasInDatabase("string")
        .schemaName("string")
        .build())
    .onSchemaObject(GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs.builder()
        .all(GrantPrivilegesToDatabaseRoleOnSchemaObjectAllArgs.builder()
            .objectTypePlural("string")
            .inDatabase("string")
            .inSchema("string")
            .build())
        .future(GrantPrivilegesToDatabaseRoleOnSchemaObjectFutureArgs.builder()
            .objectTypePlural("string")
            .inDatabase("string")
            .inSchema("string")
            .build())
        .objectName("string")
        .objectType("string")
        .build())
    .privileges("string")
    .withGrantOption(false)
    .build());

    grant_privileges_to_database_role_resource = snowflake.GrantPrivilegesToDatabaseRole("grantPrivilegesToDatabaseRoleResource",
    database_role_name="string",
    all_privileges=False,
    always_apply=False,
    always_apply_trigger="string",
    on_database="string",
    on_schema={
        "all_schemas_in_database": "string",
        "future_schemas_in_database": "string",
        "schema_name": "string",
    },
    on_schema_object={
        "all": {
            "object_type_plural": "string",
            "in_database": "string",
            "in_schema": "string",
        },
        "future": {
            "object_type_plural": "string",
            "in_database": "string",
            "in_schema": "string",
        },
        "object_name": "string",
        "object_type": "string",
    },
    privileges=["string"],
    with_grant_option=False)

    const grantPrivilegesToDatabaseRoleResource = new snowflake.GrantPrivilegesToDatabaseRole("grantPrivilegesToDatabaseRoleResource", {
    databaseRoleName: "string",
    allPrivileges: false,
    alwaysApply: false,
    alwaysApplyTrigger: "string",
    onDatabase: "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:GrantPrivilegesToDatabaseRole
properties:
    allPrivileges: false
    alwaysApply: false
    alwaysApplyTrigger: string
    databaseRoleName: string
    onDatabase: 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
    withGrantOption: false

    GrantPrivilegesToDatabaseRole Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The GrantPrivilegesToDatabaseRole resource accepts the following input properties:

    DatabaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    AllPrivileges bool
    Grant all privileges on the database role.
    AlwaysApply bool
    AlwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    OnDatabase string
    The fully qualified name of the database on which privileges will be granted.
    OnSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    Privileges List<string>
    The privileges to grant on the database role.
    WithGrantOption bool
    If specified, allows the recipient role to grant the privileges to other roles.
    DatabaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    AllPrivileges bool
    Grant all privileges on the database role.
    AlwaysApply bool
    AlwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    OnDatabase string
    The fully qualified name of the database on which privileges will be granted.
    OnSchema GrantPrivilegesToDatabaseRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    Privileges []string
    The privileges to grant on the database role.
    WithGrantOption bool
    If specified, allows the recipient role to grant the privileges to other roles.
    databaseRoleName String
    The fully qualified name of the database role to which privileges will be granted.
    allPrivileges Boolean
    Grant all privileges on the database role.
    alwaysApply Boolean
    alwaysApplyTrigger String
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    onDatabase String
    The fully qualified name of the database on which privileges will be granted.
    onSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the database role.
    withGrantOption Boolean
    If specified, allows the recipient role to grant the privileges to other roles.
    databaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    allPrivileges boolean
    Grant all privileges on the database role.
    alwaysApply boolean
    alwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    onDatabase string
    The fully qualified name of the database on which privileges will be granted.
    onSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges string[]
    The privileges to grant on the database role.
    withGrantOption boolean
    If specified, allows the recipient role to grant the privileges to other roles.
    database_role_name str
    The fully qualified name of the database role to which privileges will be granted.
    all_privileges bool
    Grant all privileges on the database role.
    always_apply bool
    always_apply_trigger str
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    on_database str
    The fully qualified name of the database on which privileges will be granted.
    on_schema GrantPrivilegesToDatabaseRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    on_schema_object GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    privileges Sequence[str]
    The privileges to grant on the database role.
    with_grant_option bool
    If specified, allows the recipient role to grant the privileges to other roles.
    databaseRoleName String
    The fully qualified name of the database role to which privileges will be granted.
    allPrivileges Boolean
    Grant all privileges on the database role.
    alwaysApply Boolean
    alwaysApplyTrigger String
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    onDatabase String
    The fully qualified name of the database 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 database role.
    withGrantOption Boolean
    If specified, allows the recipient role to grant the privileges to other roles.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the GrantPrivilegesToDatabaseRole 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 GrantPrivilegesToDatabaseRole Resource

    Get an existing GrantPrivilegesToDatabaseRole 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?: GrantPrivilegesToDatabaseRoleState, opts?: CustomResourceOptions): GrantPrivilegesToDatabaseRole
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        all_privileges: Optional[bool] = None,
        always_apply: Optional[bool] = None,
        always_apply_trigger: Optional[str] = None,
        database_role_name: Optional[str] = None,
        on_database: Optional[str] = None,
        on_schema: Optional[GrantPrivilegesToDatabaseRoleOnSchemaArgs] = None,
        on_schema_object: Optional[GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs] = None,
        privileges: Optional[Sequence[str]] = None,
        with_grant_option: Optional[bool] = None) -> GrantPrivilegesToDatabaseRole
    func GetGrantPrivilegesToDatabaseRole(ctx *Context, name string, id IDInput, state *GrantPrivilegesToDatabaseRoleState, opts ...ResourceOption) (*GrantPrivilegesToDatabaseRole, error)
    public static GrantPrivilegesToDatabaseRole Get(string name, Input<string> id, GrantPrivilegesToDatabaseRoleState? state, CustomResourceOptions? opts = null)
    public static GrantPrivilegesToDatabaseRole get(String name, Output<String> id, GrantPrivilegesToDatabaseRoleState 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 database role.
    AlwaysApply bool
    AlwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    DatabaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    OnDatabase string
    The fully qualified name of the database on which privileges will be granted.
    OnSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    Privileges List<string>
    The privileges to grant on the database role.
    WithGrantOption bool
    If specified, allows the recipient role to grant the privileges to other roles.
    AllPrivileges bool
    Grant all privileges on the database role.
    AlwaysApply bool
    AlwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    DatabaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    OnDatabase string
    The fully qualified name of the database on which privileges will be granted.
    OnSchema GrantPrivilegesToDatabaseRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    OnSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    Privileges []string
    The privileges to grant on the database role.
    WithGrantOption bool
    If specified, allows the recipient role to grant the privileges to other roles.
    allPrivileges Boolean
    Grant all privileges on the database role.
    alwaysApply Boolean
    alwaysApplyTrigger String
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    databaseRoleName String
    The fully qualified name of the database role to which privileges will be granted.
    onDatabase String
    The fully qualified name of the database on which privileges will be granted.
    onSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges List<String>
    The privileges to grant on the database role.
    withGrantOption Boolean
    If specified, allows the recipient role to grant the privileges to other roles.
    allPrivileges boolean
    Grant all privileges on the database role.
    alwaysApply boolean
    alwaysApplyTrigger string
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    databaseRoleName string
    The fully qualified name of the database role to which privileges will be granted.
    onDatabase string
    The fully qualified name of the database on which privileges will be granted.
    onSchema GrantPrivilegesToDatabaseRoleOnSchema
    Specifies the schema on which privileges will be granted.
    onSchemaObject GrantPrivilegesToDatabaseRoleOnSchemaObject
    Specifies the schema object on which privileges will be granted.
    privileges string[]
    The privileges to grant on the database role.
    withGrantOption boolean
    If specified, allows the recipient role to grant the privileges to other roles.
    all_privileges bool
    Grant all privileges on the database role.
    always_apply bool
    always_apply_trigger str
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    database_role_name str
    The fully qualified name of the database role to which privileges will be granted.
    on_database str
    The fully qualified name of the database on which privileges will be granted.
    on_schema GrantPrivilegesToDatabaseRoleOnSchemaArgs
    Specifies the schema on which privileges will be granted.
    on_schema_object GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs
    Specifies the schema object on which privileges will be granted.
    privileges Sequence[str]
    The privileges to grant on the database role.
    with_grant_option bool
    If specified, allows the recipient role to grant the privileges to other roles.
    allPrivileges Boolean
    Grant all privileges on the database role.
    alwaysApply Boolean
    alwaysApplyTrigger String
    This is a helper field and should not be set. Its main purpose is to help to achieve the functionality described by the always_apply field.
    databaseRoleName String
    The fully qualified name of the database role to which privileges will be granted.
    onDatabase String
    The fully qualified name of the database 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 database role.
    withGrantOption Boolean
    If specified, allows the recipient role to grant the privileges to other roles.

    Supporting Types

    GrantPrivilegesToDatabaseRoleOnSchema, GrantPrivilegesToDatabaseRoleOnSchemaArgs

    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.

    GrantPrivilegesToDatabaseRoleOnSchemaObject, GrantPrivilegesToDatabaseRoleOnSchemaObjectArgs

    All GrantPrivilegesToDatabaseRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in either a database or schema.
    Future GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET
    All GrantPrivilegesToDatabaseRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in either a database or schema.
    Future GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET
    all GrantPrivilegesToDatabaseRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in either a database or schema.
    future GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET
    all GrantPrivilegesToDatabaseRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in either a database or schema.
    future GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET
    all GrantPrivilegesToDatabaseRoleOnSchemaObjectAll
    Configures the privilege to be granted on all objects in either a database or schema.
    future GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET
    all Property Map
    Configures the privilege to be granted on all objects in either a database or schema.
    future Property Map
    Configures the privilege to be granted on future objects in either 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 | CORTEX SEARCH SERVICE | 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 | NOTEBOOK | PACKAGES POLICY | PASSWORD POLICY | PIPE | PROCEDURE | PROJECTION POLICY | ROW ACCESS POLICY | SECRET | SERVICE | SESSION POLICY | SEQUENCE | SNAPSHOT | STAGE | STREAM | TABLE | TAG | TASK | VIEW | STREAMLIT | DATASET

    GrantPrivilegesToDatabaseRoleOnSchemaObjectAll, GrantPrivilegesToDatabaseRoleOnSchemaObjectAllArgs

    ObjectTypePlural string
    The plural object type of the schema object on which privileges will be granted. Valid values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    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 | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    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 | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    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 | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    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 | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    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 | CORTEX SEARCH SERVICES | 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 | NOTEBOOKS | PACKAGES POLICIES | PASSWORD POLICIES | PIPES | PROCEDURES | PROJECTION POLICIES | ROW ACCESS POLICIES | SECRETS | SERVICES | SESSION POLICIES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TAGS | TASKS | VIEWS | STREAMLITS | DATASETS.
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.

    GrantPrivilegesToDatabaseRoleOnSchemaObjectFuture, GrantPrivilegesToDatabaseRoleOnSchemaObjectFutureArgs

    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    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 | NOTEBOOKS | PASSWORD POLICIES | PIPES | PROCEDURES | SECRETS | SERVICES | SEQUENCES | SNAPSHOTS | STAGES | STREAMS | TABLES | TASKS | VIEWS | DATASETS.
    inDatabase String
    The fully qualified name of the database.
    inSchema String
    The fully qualified name of the schema.

    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.61.1 published on Thursday, Nov 14, 2024 by Pulumi
    pulumi/pulumi-snowflake