Snowflake v1.2.0, Apr 14 25

Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

snowflake.GrantOwnership

Explore with Pulumi AI

Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

Import

Import examples

OnObject on Schema ToAccountRole

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"|COPY|OnObject|SCHEMA|"database_name"."schema_name"'`

OnObject on Schema ToDatabaseRole

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToDatabaseRole|"database_name"."database_role_name"|COPY|OnObject|SCHEMA|"database_name"."schema_name"'`

OnObject on Table

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"|COPY|OnObject|TABLE|"database_name"."schema_name"."table_name"'`

OnAll InDatabase

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"|REVOKE|OnAll|TABLES|InDatabase|"database_name"'`

OnAll InSchema

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"||OnAll|TABLES|InSchema|"database_name"."schema_name"'`

OnFuture InDatabase

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"||OnFuture|TABLES|InDatabase|"database_name"'`

OnFuture InSchema

$ pulumi import snowflake:index/grantOwnership:GrantOwnership example 'ToAccountRole|"account_role"|COPY|OnFuture|TABLES|InSchema|"database_name"."schema_name"'`

Create GrantOwnership Resource

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

new GrantOwnership(name: string, args: GrantOwnershipArgs, opts?: CustomResourceOptions);

@overload
def GrantOwnership(resource_name: str,
                   args: GrantOwnershipArgs,
                   opts: Optional[ResourceOptions] = None)

@overload
def GrantOwnership(resource_name: str,
                   opts: Optional[ResourceOptions] = None,
                   on: Optional[GrantOwnershipOnArgs] = None,
                   account_role_name: Optional[str] = None,
                   database_role_name: Optional[str] = None,
                   outbound_privileges: Optional[str] = None)

func NewGrantOwnership(ctx *Context, name string, args GrantOwnershipArgs, opts ...ResourceOption) (*GrantOwnership, error)

public GrantOwnership(string name, GrantOwnershipArgs args, CustomResourceOptions? opts = null)

public GrantOwnership(String name, GrantOwnershipArgs args)
public GrantOwnership(String name, GrantOwnershipArgs args, CustomResourceOptions options)

type: snowflake:GrantOwnership
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 GrantOwnershipArgs: 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 GrantOwnershipArgs: 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 GrantOwnershipArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args GrantOwnershipArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args GrantOwnershipArgs: 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.

TypeScript
Python
Go
C#
Java
YAML

var grantOwnershipResource = new Snowflake.GrantOwnership("grantOwnershipResource", new()
{
    On = new Snowflake.Inputs.GrantOwnershipOnArgs
    {
        All = new Snowflake.Inputs.GrantOwnershipOnAllArgs
        {
            ObjectTypePlural = "string",
            InDatabase = "string",
            InSchema = "string",
        },
        Future = new Snowflake.Inputs.GrantOwnershipOnFutureArgs
        {
            ObjectTypePlural = "string",
            InDatabase = "string",
            InSchema = "string",
        },
        ObjectName = "string",
        ObjectType = "string",
    },
    AccountRoleName = "string",
    DatabaseRoleName = "string",
    OutboundPrivileges = "string",
});

example, err := snowflake.NewGrantOwnership(ctx, "grantOwnershipResource", &snowflake.GrantOwnershipArgs{
	On: &snowflake.GrantOwnershipOnArgs{
		All: &snowflake.GrantOwnershipOnAllArgs{
			ObjectTypePlural: pulumi.String("string"),
			InDatabase:       pulumi.String("string"),
			InSchema:         pulumi.String("string"),
		},
		Future: &snowflake.GrantOwnershipOnFutureArgs{
			ObjectTypePlural: pulumi.String("string"),
			InDatabase:       pulumi.String("string"),
			InSchema:         pulumi.String("string"),
		},
		ObjectName: pulumi.String("string"),
		ObjectType: pulumi.String("string"),
	},
	AccountRoleName:    pulumi.String("string"),
	DatabaseRoleName:   pulumi.String("string"),
	OutboundPrivileges: pulumi.String("string"),
})

var grantOwnershipResource = new GrantOwnership("grantOwnershipResource", GrantOwnershipArgs.builder()
    .on(GrantOwnershipOnArgs.builder()
        .all(GrantOwnershipOnAllArgs.builder()
            .objectTypePlural("string")
            .inDatabase("string")
            .inSchema("string")
            .build())
        .future(GrantOwnershipOnFutureArgs.builder()
            .objectTypePlural("string")
            .inDatabase("string")
            .inSchema("string")
            .build())
        .objectName("string")
        .objectType("string")
        .build())
    .accountRoleName("string")
    .databaseRoleName("string")
    .outboundPrivileges("string")
    .build());

grant_ownership_resource = snowflake.GrantOwnership("grantOwnershipResource",
    on={
        "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",
    },
    account_role_name="string",
    database_role_name="string",
    outbound_privileges="string")

const grantOwnershipResource = new snowflake.GrantOwnership("grantOwnershipResource", {
    on: {
        all: {
            objectTypePlural: "string",
            inDatabase: "string",
            inSchema: "string",
        },
        future: {
            objectTypePlural: "string",
            inDatabase: "string",
            inSchema: "string",
        },
        objectName: "string",
        objectType: "string",
    },
    accountRoleName: "string",
    databaseRoleName: "string",
    outboundPrivileges: "string",
});

type: snowflake:GrantOwnership
properties:
    accountRoleName: string
    databaseRoleName: string
    "on":
        all:
            inDatabase: string
            inSchema: string
            objectTypePlural: string
        future:
            inDatabase: string
            inSchema: string
            objectTypePlural: string
        objectName: string
        objectType: string
    outboundPrivileges: string

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

On GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
AccountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
DatabaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
OutboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

On GrantOwnershipOnArgs: Configures which object(s) should transfer their ownership to the specified role.
AccountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
DatabaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
OutboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

on GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
accountRoleName String: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName String: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
outboundPrivileges String: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

on GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
accountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
outboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

on GrantOwnershipOnArgs: Configures which object(s) should transfer their ownership to the specified role.
account_role_name str: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
database_role_name str: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
outbound_privileges str: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

on Property Map: Configures which object(s) should transfer their ownership to the specified role.
accountRoleName String: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName String: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
outboundPrivileges String: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

Outputs

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

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

TypeScript
Python
Go
C#
Java
YAML

public static get(name: string, id: Input<ID>, state?: GrantOwnershipState, opts?: CustomResourceOptions): GrantOwnership

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        account_role_name: Optional[str] = None,
        database_role_name: Optional[str] = None,
        on: Optional[GrantOwnershipOnArgs] = None,
        outbound_privileges: Optional[str] = None) -> GrantOwnership

func GetGrantOwnership(ctx *Context, name string, id IDInput, state *GrantOwnershipState, opts ...ResourceOption) (*GrantOwnership, error)

public static GrantOwnership Get(string name, Input<string> id, GrantOwnershipState? state, CustomResourceOptions? opts = null)

public static GrantOwnership get(String name, Output<String> id, GrantOwnershipState state, CustomResourceOptions options)

resources:  _:    type: snowflake:GrantOwnership    get:      id: ${id}

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:

AccountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
DatabaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
On GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
OutboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

AccountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
DatabaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
On GrantOwnershipOnArgs: Configures which object(s) should transfer their ownership to the specified role.
OutboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

accountRoleName String: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName String: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
on GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
outboundPrivileges String: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

accountRoleName string: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName string: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
on GrantOwnershipOn: Configures which object(s) should transfer their ownership to the specified role.
outboundPrivileges string: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

account_role_name str: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
database_role_name str: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
on GrantOwnershipOnArgs: Configures which object(s) should transfer their ownership to the specified role.
outbound_privileges str: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

accountRoleName String: The fully qualified name of the account role to which privileges will be granted. For more information about this resource, see docs.
databaseRoleName String: The fully qualified name of the database role to which privileges will be granted. For more information about this resource, see docs.
on Property Map: Configures which object(s) should transfer their ownership to the specified role.
outboundPrivileges String: Specifies whether to remove or transfer all existing outbound privileges on the object when ownership is transferred to a new role. Available options are: REVOKE for removing existing privileges and COPY to transfer them with ownership. For more information head over to Snowflake documentation.

Supporting Types

GrantOwnershipOn
, GrantOwnershipOnArgs

All GrantOwnershipOnAll: Configures the privilege to be granted on all objects in either a database or schema.
Future GrantOwnershipOnFuture: Configures the privilege to be granted on all objects in either a database or schema.
ObjectName string: Specifies the identifier for the object on which you are transferring ownership.
ObjectType string: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

All GrantOwnershipOnAll: Configures the privilege to be granted on all objects in either a database or schema.
Future GrantOwnershipOnFuture: Configures the privilege to be granted on all objects in either a database or schema.
ObjectName string: Specifies the identifier for the object on which you are transferring ownership.
ObjectType string: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

all GrantOwnershipOnAll: Configures the privilege to be granted on all objects in either a database or schema.
future GrantOwnershipOnFuture: Configures the privilege to be granted on all objects in either a database or schema.
objectName String: Specifies the identifier for the object on which you are transferring ownership.
objectType String: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

all GrantOwnershipOnAll: Configures the privilege to be granted on all objects in either a database or schema.
future GrantOwnershipOnFuture: Configures the privilege to be granted on all objects in either a database or schema.
objectName string: Specifies the identifier for the object on which you are transferring ownership.
objectType string: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

all GrantOwnershipOnAll: Configures the privilege to be granted on all objects in either a database or schema.
future GrantOwnershipOnFuture: Configures the privilege to be granted on all objects in either a database or schema.
object_name str: Specifies the identifier for the object on which you are transferring ownership.
object_type str: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

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 all objects in either a database or schema.
objectName String: Specifies the identifier for the object on which you are transferring ownership.
objectType String: Specifies the type of object on which you are transferring ownership. Available values are: AGGREGATION POLICY | ALERT | AUTHENTICATION POLICY | COMPUTE POOL | DATA METRIC FUNCTION | DATABASE | DATABASE ROLE | DYNAMIC TABLE | EVENT TABLE | EXTERNAL TABLE | EXTERNAL VOLUME | FAILOVER GROUP | FILE FORMAT | FUNCTION | GIT REPOSITORY | HYBRID TABLE | ICEBERG TABLE | IMAGE REPOSITORY | INTEGRATION | MATERIALIZED VIEW | NETWORK POLICY | NETWORK RULE | PACKAGES POLICY | PIPE | PROCEDURE | MASKING POLICY | PASSWORD POLICY | PROJECTION POLICY | REPLICATION GROUP | RESOURCE MONITOR | ROLE | ROW ACCESS POLICY | SCHEMA | SESSION POLICY | SECRET | SEQUENCE | STAGE | STREAM | TABLE | TAG | TASK | USER | VIEW | WAREHOUSE

GrantOwnershipOnAll
, GrantOwnershipOnAllArgs

ObjectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
InDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
InSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

ObjectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
InDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
InSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural String: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase String: The fully qualified name of the database. For more information about this resource, see docs.
inSchema String: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
inSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

object_type_plural str: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
in_database str: The fully qualified name of the database. For more information about this resource, see docs.
in_schema str: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural String: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase String: The fully qualified name of the database. For more information about this resource, see docs.
inSchema String: The fully qualified name of the schema. For more information about this resource, see docs.

GrantOwnershipOnFuture
, GrantOwnershipOnFutureArgs

ObjectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
InDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
InSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

ObjectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
InDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
InSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural String: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase String: The fully qualified name of the database. For more information about this resource, see docs.
inSchema String: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural string: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase string: The fully qualified name of the database. For more information about this resource, see docs.
inSchema string: The fully qualified name of the schema. For more information about this resource, see docs.

object_type_plural str: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
in_database str: The fully qualified name of the database. For more information about this resource, see docs.
in_schema str: The fully qualified name of the schema. For more information about this resource, see docs.

objectTypePlural String: Specifies the type of object in plural form on which you are transferring ownership. Available values are: AGGREGATION POLICIES | ALERTS | AUTHENTICATION POLICIES | COMPUTE POOLS | DATA METRIC FUNCTIONS | DATABASES | DATABASE ROLES | DYNAMIC TABLES | EVENT TABLES | EXTERNAL TABLES | EXTERNAL VOLUMES | FAILOVER GROUPS | FILE FORMATS | FUNCTIONS | GIT REPOSITORIES | HYBRID TABLES | ICEBERG TABLES | IMAGE REPOSITORIES | INTEGRATIONS | MATERIALIZED VIEWS | NETWORK POLICIES | NETWORK RULES | PACKAGES POLICIES | PIPES | PROCEDURES | MASKING POLICIES | PASSWORD POLICIES | PROJECTION POLICIES | REPLICATION GROUPS | RESOURCE MONITORS | ROLES | ROW ACCESS POLICIES | SCHEMAS | SESSION POLICIES | SECRETS | SEQUENCES | STAGES | STREAMS | TABLES | TAGS | TASKS | USERS | VIEWS | WAREHOUSES. For more information head over to Snowflake documentation.
inDatabase String: The fully qualified name of the database. For more information about this resource, see docs.
inSchema String: The fully qualified name of the schema. For more information about this resource, see docs.

Package Details

Repository: Snowflake pulumi/pulumi-snowflake
License: Apache-2.0
Notes: This Pulumi package is based on the snowflake Terraform Provider.

Snowflake v1.2.0 published on Monday, Apr 14, 2025 by Pulumi

pulumi/pulumi-snowflake

snowflake.GrantOwnership

On this page

On this page

Import

Import examples

OnObject on Schema ToAccountRole

OnObject on Schema ToDatabaseRole

OnObject on Table

OnAll InDatabase

OnAll InSchema

OnFuture InDatabase

OnFuture InSchema

Create GrantOwnership Resource

Constructor syntax

Parameters

Constructor example

GrantOwnership Resource Properties

Inputs

Outputs

Look up Existing GrantOwnership Resource

Supporting Types

GrantOwnershipOn
, GrantOwnershipOnArgs

GrantOwnershipOnAll
, GrantOwnershipOnAllArgs

GrantOwnershipOnFuture
, GrantOwnershipOnFutureArgs

Package Details

On this page

On this page

snowflake.GrantOwnership

On this page

On this page

Import

Import examples

OnObject on Schema ToAccountRole

OnObject on Schema ToDatabaseRole

OnObject on Table

OnAll InDatabase

OnAll InSchema

OnFuture InDatabase

OnFuture InSchema

Create GrantOwnership Resource

Constructor syntax

Parameters

Constructor example

GrantOwnership Resource Properties

Inputs

Outputs

Look up Existing GrantOwnership Resource

Supporting Types

GrantOwnershipOn, GrantOwnershipOnArgs

GrantOwnershipOnAll, GrantOwnershipOnAllArgs

GrantOwnershipOnFuture, GrantOwnershipOnFutureArgs

Package Details

On this page

On this page

GrantOwnershipOn
, GrantOwnershipOnArgs

GrantOwnershipOnAll
, GrantOwnershipOnAllArgs

GrantOwnershipOnFuture
, GrantOwnershipOnFutureArgs