Hi
How can I give the Metabase user future access to the new schema automatically
**
**
I think that’s more of a question you need to ask yourself 
… Since it’s independent of metabase but totally dependent on the DB you’re using.
Metabase uses the user permissions so it depends what DB you’re using. If postgres, they have a handy ALTER DEFAULT PRIVILEGES you can use here:
1 Like
When you say “the Metabase user,” are you talking about the user that Metabase logs into the database as, or users in Metabase itself?
I think @TonyC answered the former question, how to ensure the Metabase database user gets access to new database objects.
For the latter, when new objects are added to the database and Metabase syncs the schema, Metabase will copy the permissions from the parent object. If users/groups in Metabase don’t have query access to the database, they won’t gain access to new schemas automatically, even if they have access to other schemas.
Things change if you are on a paid plan and are using Impersonation, as then Metabase users are accessing the database via a unique database user, which will have its own grants.
1 Like