I thought Metabase was readonly?

Get Help
1

I thought Metabase was readonly,

I ws able to update a value with a simple query:
UPDATE x SET y WHERE z;

I want to make sure that there is no way, any team member using Metabase cannot edit anything. Looking for tips to make that happen

2

Hi @goktugyilmaz
You should create a database user that doesn't have write privileges.

3

Is 'SQL Queries' the only place you can do write operations?
So that means admins will always have write privileges?

4

@goktugyilmaz

Is 'SQL Queries' the only place you can do write operations?

It is not possible to create write operations in the GUI.

So that means admins will always have write privileges?

No, if you create a database user (meaning a user you create on your database, nothing to do with Metabase), that only has select-privileges, and use that user for the connection in Metabase, then Metabase cannot do more than what the privileges allow.

1 Like