It is now possible using the database roles in your provider account. Please see: https://community.snowflake.com/s/article/How-to-use-Database-Roles-in-a-Data-Share