grants

Creates, updates, deletes, gets or lists a grants resource.

Overview

Name	grants
Type	Resource
Id	snowflake.user.grants

Fields

Name	Datatype	Description
containing_scope	object
created_on	string	Date and time when the grant was created
granted_by	string	The role that granted this privilege to this grantee
privileges	array	List of privileges to be granted.
securable	object
securable_type	string	Type of the securable to be granted. Only ROLE is supported

Methods

Name	Accessible by	Required Params	Description
list_grants	SELECT	name, endpoint	List all grants to the user
grant	INSERT	name, data__securable_type, endpoint	Grant a role to the user
revoke_grants	DELETE	name, data__securable_type, endpoint	Revoke grants from the user

SELECT examples

List all grants to the user

SELECT
containing_scope,
created_on,
granted_by,
privileges,
securable,
securable_type
FROM snowflake.user.grants
WHERE name = '{{ name }}'
AND endpoint = '{{ endpoint }}';

INSERT example

Use the following StackQL query and manifest file to create a new grants resource.

Required Properties

/*+ create */
INSERT INTO snowflake.user.grants (
data__securable,
data__containing_scope,
data__securable_type,
data__privileges,
name,
endpoint
)
SELECT 
'{{ securable }}',
'{{ containing_scope }}',
'{{ securable_type }}',
'{{ privileges }}',
'{{ name }}',
'{{ endpoint }}'
;

All Properties

/*+ create */
INSERT INTO snowflake.user.grants (
data__securable_type,
name,
endpoint
)
SELECT 
'{{ securable_type }}',
'{{ name }}',
'{{ endpoint }}'
;

Manifest

- name: grants
  props:
    - name: name
      value: string
    - name: data__securable_type
      value: string
    - name: endpoint
      value: string
    - name: securable
      props:
        - name: database
          value: string
        - name: schema
          value: string
        - name: name
          value: string
    - name: containing_scope
      props:
        - name: database
          value: string
        - name: schema
          value: string
    - name: securable_type
      value: string
    - name: privileges
      value: array

DELETE example

Deletes the specified grants resource.

/*+ delete */
DELETE FROM snowflake.user.grants
WHERE name = '{{ name }}'
AND data__securable_type = '{{ data__securable_type }}'
AND endpoint = '{{ endpoint }}';