# Grant

[Snowflake Documentation](https://docs.snowflake.com/en/sql-reference/sql/grant-privilege)

Represents a grant of privileges on a resource to a role in Snowflake.

## Examples

### Python

```python
# Global Privs:
grant = Grant(priv="CREATE WAREHOUSE", on="ACCOUNT", to="somerole")
# Warehouse Privs:
grant = Grant(priv="OPERATE", on=Warehouse(name="foo"), to="somerole")
grant = Grant(priv="OPERATE", on_warehouse="foo", to="somerole")
# Schema Privs:
grant = Grant(priv="CREATE TABLE", on=Schema(name="foo"), to="somerole")
grant = Grant(priv="CREATE TABLE", on_schema="foo", to="somerole")
# Table Privs:
grant = Grant(priv="SELECT", on_table="sometable", to="somerole")
```

### YAML

```yaml
- Grant:
    priv: "SELECT"
    on_table: "some_table"
    to: "some_role"
    grant_option: true
```

## Fields

* `priv` (string, required) - The privilege to grant. Examples include 'SELECT', 'INSERT', 'CREATE TABLE'.
* `on` (string or [Resource](https://github.com/Titan-Systems/titan/blob/main/docs/resources/resource.md), required) - The resource on which the privilege is granted. Can be a string like 'ACCOUNT' or a specific resource object.
* `to` (string or [Role](https://titan-core.gitbook.io/titan-core/resources/role), required) - The role to which the privileges are granted.
* `grant_option` (bool) - Specifies whether the grantee can grant the privileges to other roles. Defaults to False.
* `owner` (string or [Role](https://titan-core.gitbook.io/titan-core/resources/role)) - The owner role of the grant. Defaults to 'SYSADMIN'.