Is there a way to grant more granular permissions?

Get Help
1

Hi,

I am looking to get more granular permission levels in Metabase.
Perhaps it is there already and I am just missing it but I only see "data access" or "SQL Queries".

Is there a way to say allow someone to use SQL but only for SELECT operations?

Thanks,
Anthony

2

Hi @anthony.owens
You control that through the database user privileges, not through Metabase.
Metabase should almost only have select privileges to any databases, it's a reporting tool. There are some cases, where other privileges might be needed because of temp tables, but that depends on the database type, your data and the queries made, so it's easier to allow that after the fact, when you see errors in the logs.

There's Sandboxing, which allows for granular row/column permissions:
https://www.metabase.com/learn/permissions/data-sandboxing-row-permissions