# Snowflake permissions - Insufficient privileges to operate on table

**URL:** <https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948>\
**Category:** Help\
**Tags:** snowflake, dbt-cloud\
**Created:** [January 28, 2025, 3:52pm UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948 "2025-01-28T15:52:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lau\_com](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@lau\_com](https://discourse.getdbt.com/u/lau_com)\
**Post date:** [January 28, 2025, 3:52pm UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948/1 "2025-01-28T15:52:53Z")

</div>

Hi, I am trying to create a Snowflake user that will run my dbt jobs. I have been using my accountadmin user and it has been fine so far, but when I created a user for dbt purposes only, I am encountering problems with the grants the role should have and keep getting ‘Insufficient privileges to operate on table xx’ message when I try to do a dbt run (in dbt cloud).

I have granted a lot of privileges to the database, schema, tables, views, and when I check a particular table I can see the dbt user has all these privileges:

APPLYBUDGET  
DELETE  
EVOLVE SCHEMA  
INSERT  
REBUILD  
REFERENCES  
SELECT  
TRUNCATE  
UPDATE

The only privilege that is missing is the OWNERSHIP, but it belongs to the accountadmin, so I am running out of options of what to do to keep a separate user with the minimum amount of privileges that are required for dbt.

I appreciate all the help I can get 🙂

---

<div class="post-metadata">

**Author:** ![DataNath](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/datanath/32/4070_2.png) [@DataNath](https://discourse.getdbt.com/u/DataNath)\
**Post date:** [January 29, 2025, 4:46pm UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948/2 "2025-01-29T16:46:29Z")

</div>

Hi @lau_com, does your role also have the right level of perms on the WAREHOUSE?

---

<div class="post-metadata">

**Author:** ![lau\_com](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@lau\_com](https://discourse.getdbt.com/u/lau_com)\
**Post date:** [January 30, 2025, 8:38am UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948/3 "2025-01-30T08:38:34Z")

</div>

These are the privileges that the role has on the warehouse:  
APPLYBUDGET  
MODIFY  
MONITOR  
OPERATE  
USAGE

---

<div class="post-metadata">

**Author:** ![DataNath](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/datanath/32/4070_2.png) [@DataNath](https://discourse.getdbt.com/u/DataNath)\
**Post date:** [January 30, 2025, 10:14am UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948/4 "2025-01-30T10:14:23Z")

</div>

I’m wondering if you also need USAGE on the database/schema @lau_com.

---

<div class="post-metadata">

**Author:** ![lau\_com](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@lau\_com](https://discourse.getdbt.com/u/lau_com)\
**Post date:** [January 30, 2025, 10:44am UTC](https://discourse.getdbt.com/t/snowflake-permissions-insufficient-privileges-to-operate-on-table/17948/5 "2025-01-30T10:44:34Z")

</div>

I also have that on all databases and schemas